Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15 Answers
- 26051 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ganesh
First declare variable parameters start value =0 and end
value=1000. Then, connect sour > seq > filter > target.
assign the seq start value = start value and end value = end
value. it will pass first 1000 records. next time increment
the variable parameter by 1000 for both start and end value.
then, it will send the next 2000 records. then, do the same
process for the remaining.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the components of Informatica? And what is the purpose of each?
How to Create a folder using pmrep command?
What is status code in informatica?
What is workflow manager?
Explain direct and indirect flat file loading (source file type) - informatica
How many ways are there to create ports?
What are the designer tools for creating transformations?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the difference between informatics 7x and 8x and what is latest version?
Describe expression transformation?
how we can load rejected record's at run time?(not through bad files)
What is event and what are the tasks related to it?
What is option by which we can run all the sessions in a batch simultaneously?
What is sorter transformation?
