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 / praveen
You can use override query in the source qualifier and set it to read rownum <= 10000. This will load the first, similar way you can do the remaining.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is domain and gateway node?
Differences between version 7.x and 8.x.
How to update source definition?
What is the benefit of session partitioning?
What is joiner change?
generate date / time dimension in informatica
Difference between Target-based loading and constraint-based loading?
What are the prerequisite tasks to achieve the session partition?
What is lookup transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are mapplets? How is it different from a Reusable Transformation?
What is the difference between informatics 7x and 8x and what is latest version?
Differentiate between router and filter transformation?
How do you update the records with or without using update strategy?