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?
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
Tell me about Propagate functions in informatica
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is a router transformation?
Why union transformation is an active transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Explain incremental aggregation in informatica
Why sorter is an active transformation?
What is lookup change?
Explain direct and indirect flat file loading (source file type) - informatica
What is a filter transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?