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 / sujatha
Hi,
First declare mapping variable like $$rec_load in mapping tab under parameters/variables.
next in expression transformation declare one port like rec_count=setvariable($$rec_load,$$rec_load+1000)
first time $$rec_load having value zero.next time it will load 1000 records like that every run it will increment 1000 records.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What does role playing dimension mean?
How big was your fact table
what is the size of your data warehousing?
Briefly define reusable transformation?
What is difference between a gateway node and worker node?
How to start a workflow using pmcmd command?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the function of look up transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to go to the older version for a mapping?
Explain what transformation and how many are there in informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Repository user profiles
What is joiner change?