|
Question |
Rating |
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What r the reusable transforamtions?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is the difference between Narmal load and Bulk load?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Differences between connected and unconnected lookup?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Explain about Recovering sessions? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Can anyone explain error handling in informatica with examples so that it will be easy to explain the same in the interview.
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
what r the settiings that u use to cofigure the joiner transformation?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What are mapping parameters and varibles in which situation we can use it
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Can U use the maping parameters or variables created in one maping into another maping?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What happens if you try to create a shortcut to a non-shared folder?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What are the mapings that we use for slowly changing dimension table? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Why did you use stored procedure in your ETL Application?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts assigning the next value of the saved value. for example i ran a session and in the end it stored a value of 50 to the repository.next time when i run the session, it should start with the value of 70. not with the value of 51.
how to do this.
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is the look up transformation? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
How do you load the time dimension.
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is a transforamation? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is a source qualifier?-
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is the hierarchies in DWH
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
what is the look up transformation?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
How can we store previous session logs
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is aggregate cache in aggregator transforamtion? |
|
View Answer |