Answer Posted / kunkala.ramakrishna
IF THE SOURCE CHANGES ONLY INCREMENTLY AND U CAN CAPTURE THOSE CHANGES
YOU CAN CONFIGURE THE SESSION TO PROCESS ONLY THOSE CHANGES
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is decode in static cache?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How can we use mapping variables in informatica? Where do we use them?
How are indexes created after completing the load process?
Explain the types of transformations?
Write the unconnected lookup syntax?
What is pmcmd command?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a difference between complete, stop and abort?
what is the size of your data warehousing?
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 to use pmcmd utility command?
Why do you use Mapping Parameter and mapping variable?
What are the new features of Power Center 5.0?
Can we get 1st record through Informatica(without sequence number).