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 / sanjay
If you want to load these records on different files at
different time, you can use Filter transformation else u can
use Router transformation..
In Router trans create two ports and one default port.. and
write conditions according to your requirement....
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
what is Active lock explain
Informatica settings are available in which file?
Can u generate reports in Informatica?
what are the Methods For Creating Reusable Transformations?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
how to load rows into fact table in data warehouse
What are the different types of transformation available in informatica.
What is the scenario which compels informatica server to reject files?
What is an expression transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What does role playing dimension mean?
Explain about Informatica server process that how it works relates to mapping variables?
What are the settings that you use to configure the joiner transformation?