Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
Answer Posted / muddam
First declare variable paramater as las_extract_date and
create port as last_updated_date and connect source.qf
transforamtion override, give as where
last_ext_dt>=last_update_date with time stamp it will work
out.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
without table how to come first record only in oracle?
What does role playing dimension mean?
How to extract sap data using informatica?
How can we store previous session logs?
What if the source is a flat-file?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How identifying bottlenecks in various components of informatica and resolving them?
What is the function of aggregator transformation?
What is sq transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Define the various join types of joiner transformation?
Explain what are the different versions of informatica?
Different sorts of metadata that stores in the storage facility?
in reporting we add some new objects,how we get the count of the newly added objects to the report