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 are the main issues while working with flat files as source and as targets ?
Write the prerequisite tasks to achieve the session partition?
What is a grid in Informatica?
What will be the approach?
What is the use of code page?
How many ways a relational source definition can be updated and what are they?
What is a dimensional model?
Is it possible to define a single node as a Gateway node as well as worker node?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
In informatica workflow manager, how many repositories can be created?
How many transformations can be used in mapplets.
How to partition the Session?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain the informatica workflow?
What is the advantage of informatica?