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


Please Help Members By Posting Answers For Below Questions

Enlist few areas or real-time situations where informatica is required.

588


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1649


How can you validate all mappings in the repository simultaneously?

754


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4776


What are the components of Informatica? And what is the purpose of each?

618






How to differentiate between the active and passive transformations?

623


In informatics server which files are created during the session rums?

633


Why do you use Mapping Parameter and mapping variable?

1282


what is the hint? how to use it to reduce the query processing in program?

6296


Explain the different dimensions.

550


How can a transformation be made reusable?

661


What you know about transaction control transformation?

556


What are the different ways to implement parallel processing in informatica?

861


What is union transformation?

571


How can informatica be used for an organization?

651