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 the format of informatica objects in a repository?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the different transaction levels available in transaction control transformation?
What differs when we choose the sorted input for aggregator transformation?
How to create the source and target database connections in server manager?
permutations of mapplet
What are the data movement modes in informatica?
Performance tuning( what you did in performance tuning)
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the difference between STOP and ABORT options in Workflow Monitor?
How do you load only null records into target? Explain through mapping flow.
What are the prerequisite tasks to achieve the session partition?
Briefly describe lookup transformation?
Explain the difference between a data warehouse and a data mart?