Explain pushdown optimization and types in informatica


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

Post New Answer

More Informatica Interview Questions

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,


scd methodology?

2 Answers  


What is limitations of truncate and load option

1 Answers   Cap Gemini,


what is the dashbords?

1 Answers   IBM,


what is surrogate id ?

3 Answers   IBM,


in which situations do u go for starflake schema ?

6 Answers   TCS,


can we use bulk loading when we use look in mapping

1 Answers   TCS,


without table how to come first record only in oracle?

0 Answers  


What all join we can perform in LOOKUP transformation?

0 Answers  


i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  


Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,


Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,


Categories