Answer Posted / sagar chowdary
By using the date column in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
With this in mind, I will expect a load pattern like this
Every extract from the source will be a full load
Every load in terms of records, will be equal to last load + new records – deleted records
80-90 % of the extracted records will already exist in the valid table instance
Every load will be incrementally larger than the previous load, as more records are added to the sourceThinking
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Write the unconnected lookup syntax?
What is dimensional table? Explain the different dimensions.
How do you remove duplicate records in informatica? And how many ways are there to do it?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to create the source and target database connections in server manager?
What is dimensional table?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
EXL informatica Questions
Name at least 5 different types of transformations used in mapping design and state the use of each.?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
draw informatica architecture 8.6 ?
Explain in detail about scd type 1 through mapping.
Write the unconnected lookup syntax and how to return more than one column.
