Interested to Buy Any Domain ? << Click Here >> for more details...
I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
- 5 Answers
- 11413 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / rucha
i will use a sequence generator to get the row number then
input this sequence numbers to an expression transformation
where i will give an if condition (row number mod 3) then
the result be stored in a variable port say x.this variable
port value is filtered using router transformation as rows
with x=1 in group1,x=2 in group 2 and x=3 in default. the
resultant groups are connected to the targets 1,2 and 3
respectively
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
explain about unit testing? in real time?
During the running session, output files are created by informatica server. Enlist few of them.
When do you use sql override in a lookup transformation?
Which transformation should we use to normalise the COBOL and relational sources?
How can we delete duplicate rows from flat files?
What is an unconnected transformation?
How does a rank transform differ from aggregator transform functions max and min?
What is the difference between router and filter?
What is status code in informatica?
What is the need of etl tools?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is blocking transformation?
How to update or delete the rows in a target, which do not have key fields?
Differentiate between Load Manager and DTM?
Briefly define a session task?
