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
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the data movement modes in informatica?
What is the maplet?
What is InformaticaPowerCenter?
What are the guidelines to be followed while using union transformation?
tell me about your project functionality
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Why do we need informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Define sessions in informatica etl?
What is target designer and target load order?
What is the use of target designer?
What is primary and backup node?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the main features of Oracle 8i with context to datawarehouse?