By using the date column in the source we do incremental load, specifying

HOW DO YOU PARFORM INCREMENTAL LAOD ?

Question Posted / sagar chowdary

7 Answers
16376 Views
SAIC, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is aggregator transformation in informatica?

896

whats the logic to load the lower level of granularity of data to fact table.

2206

How can you differentiate between powercenter and power map?

1018

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1977

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1049

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

4677

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

982

What are the different types of repositories created using informatica?

1060

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2057

Explain pushdown optimization $pushdownconfig parameter - informatica

1079

What are the tasks that can be performed using sq?

1024

What is data movement mode in Informatica and difference between them?

1057

What are the different options available for update strategy?

938

What is native users?

1100

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1628