What is the term PIPELINE in informatica ?
Answer Posted / santoshi
its informatica utility
Is This Answer Correct ? | 2 Yes | 22 No |
Post New Answer View All Answers
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is rank index in rank transformation?
Write the advantages of partitioning a session?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the transformations that are not supported in mapplet?
How to use pmcmd utility command?
Explain in detail about scd type 1 through mapping.
What is pmcmd command?
Differences between version 7.x and 8.x.
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.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What all join we can perform in LOOKUP transformation?
What is the need for an etl tool?
What is the use of an aggregator cache file?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?