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 reusable transformation?
What is rank transform?
What is aggregator transformation in informatica?
what is the difference between informatica6.1 and infomatica7.1
What is joiner transformation?
What is a repository? And how to add it in an informatica client?
What is a pre-defined event and user-defined event?
Explain the mapping variable usage example in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How might you approve all mappings in the archive all the while?
How do you convert single row from source into three rows into target?
what is the -ve test case in your project.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the new features of informatica 9.x at the developer level?
Performance tuning( what you did in performance tuning)