How big was your fact table


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  


If informatica has its scheduler why using third party scheduler?

0 Answers  


Differentiate between Load Manager and DTM?

0 Answers  


in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,


what is the difference between stop and abort?

3 Answers   TCS,






Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  


Explain the informatica workflow?

0 Answers  


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,


What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,


guys which is the best institute in banglore to learn informatica??

2 Answers  


Categories