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 hattikal
src---->sq---->exp1--->filter---->exp2---->tgt
sequence gen---^
create mapping variable $run=1000/ in exp2 $run=$run+1000
in filter sequence <$run
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Enlist few areas or real-time situations where informatica is required.
What is the status code in stored procedure transformation?
What differs when we choose the sorted input for aggregator transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the modules in Power Center
What is the commit type if you have a transaction control transformation in the mapping?
What are the various types of transformation?
What are the different components of powercenter?
Define sessions in informatica etl?
What are the differences between oltp and olap?
What is informatica?
What is different between the data warehouse and data mart?
What is lookup transformation?
How would you copy the content of one repository to another repository?
Implementation methodology