Want to know about Training Centres for Informatica, Cognos
and ETL Softwares in Mumbai, India.
- 27 Answers
- 41206 Views
- I also Faced
- E-Mail Answers
Answer Posted / john
learncognosbi@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are mapplets? How is it different from a Reusable Transformation?
Mention few advantages of router transformation over filter transformation.
What are the guidelines to be followed while using union transformation?
Name the different lookup cache(s)?
What is the surrogate key?
What is the difference between source qualifier transformations source filter to filter transformation?
Reusable transformation and shortcut differences
Under which circumstances, informatica server creates reject files?
How can you differentiate between powercenter and power map?
What is the use of target designer?
Repository user profiles
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Can we create a node as a gateway node and the same node can be assigned to a grid?
