what is incremental loading ?
Answer Posted / vijay
increamental loading is the concept of capturing the new
records and updated records from the source it is very help
full in scd's - 2
Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the difference between stop and abort in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Mention few power centre client applications with their basic purpose?
list out all the transformations which use cache?
What are mapplets?
Design a mapping to load a target table with the following values from the above source?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the types of data warehouses?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is source qualifier transformation in informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com