|
Question |
Rating |
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Can anyone explain about incremental aggregation with an example?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
If u had to split the source level key going into two seperate tables. One as surrogate and other as primary. Since informatica does not gurantee keys are loaded properly(order!) into those tables. What are the different ways you could handle this type of situation?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Which objects are required by the debugger to create a valid debug session?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What r the types of groups in Router transformation?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
How the informatica server sorts the string values in Ranktransformation?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Which tool U use to create and manage sessions and batches and to monitor and stop the informatica server?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is difference between maplet and reusable transformation?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
In the source, if we also have duplicate records and we have 2 targets, T1- for unique values and T2- only for duplicate values. How do we pass the unique values to T1 and duplicate values to T2 from the source to these 2 different targets in a single mapping?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
How to recover sessions in concurrent batches? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is Code Page used for? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is Load Manager? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
How can we eliminate duplicate rows from flat file?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Why we use stored procedure transformation?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
How do we do unit testing in informatica? How do we load data in informatica ?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
In realtime which one is better star schema or snowflake star schema
the surrogate will be linked to which columns in the dimension table.
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Could anyone please tell me what are the steps required for type2 dimension/version data mapping. how can we implement it
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What is difference between stored procedure transformation and external procedure transformation? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
What are partition points?
|
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Can you copy the session to a different folder or repository? |
|
View Answer |
![](//www.coolinterview.com/images/bullet3761.gif) |
Diff between static and dynamic cache? and please explain with one example? |
|
View Answer |