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
- 25537 Views
- TCS, I also Faced
- E-Mail Answers
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
Under which circumstances, informatica server creates reject files?
When do you use sql override in a lookup transformation?
What are the components of Informatica? And what is the purpose of each?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Write the different tools in the workflow manager?
Different qualification between a related rotate toward the sky and isolates look upward?
How to elaborate powercenter integration service?
What does “tail –f” command do and what is its use as an Informatica admin.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are active and passive transformations?
Explain Dataware house architecture .how data flow from intial to end?
What are ETL Tools?
Which files are created during the session rums by informatics server?
Please let me know how to make encryption and decryption with example?
What is a code page?
