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
What is data movement mode in Informatica and difference between them?
What are the reusable transformations?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is a predefined event?
Explian the Process of deployment groups in informatica
What is union transformation in informatica?
What are the limitations of joiner transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is joiner transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the way to execute pl/sql script using informatica mapping?
What are the modules in Power Center
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com