Answer Posted / priya
look up transformation is used to look the data either from
source or target whenever the req feild is not in the
mapping.
we can use two or more tables as look up by using the join
condition
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How many ways are there to create ports?
Describe an informatica powercenter?
Enterprise data warehouse your projects phase by phase explain?
What is workflow? What are the components of workflow manager?
How can one identify whether mapping is correct or not without connecting session?
How do you take back up of repository?
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.
Explain about cumulative Sum or moving sum?
Separate from an archive server and a powerhouse?
What are pre and post-session shell commands?
Differentiate between sessions and batches?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain target update override in informatica
What is the use of target designer?
What is a pre-defined event and user-defined event?