Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
Answer Posted / anu
sq->(seq)->exp->rtr->emp1(condition rowid <=100)
->emp2(condition rowid >100 and rowid<=200)
->emp3(condition rowid >200 and rowid<=300)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=300
currval=1
cycle check it save it.
Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
I have a flat file, want to reverse the contents of the flat file
Explain scd type 3 through mapping.
Explain pushdown optimization $pushdownconfig parameter - informatica
How to open an older version of an object in the workspace?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Define the various join types of joiner transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
have u done any performance tuning? how u ll do?
Whats there in global repository
what is the complex transformation you used in informatica
What is a node in Informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the designer tools for creating transformations?
Global and Local shortcuts. Advantages.
What is target designer and target load order?