following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
Answer Posted / gangadhar
Hi suresh you are 50% current
sq-->expression-----> rooter----->t1
seqno/ ------t2
-------t3
drag the all columns to expression create one new column this column connect sequence generator connect NEXT VALUE
In sequence generator set the properties
start value 1
end value 3
cycle yes
later exp-->router connect hear create 3 groups
group1-NEXT VALUE=1
group2-NEXT VALUE=2
group3-NEXT VALUE=3
first group connect to T1
second group connect to t2
third group connect to t3
is 100% correct
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to partition the Session?
define galaxy repository in informatica
What is a joiner transformation and why it is an active one?
What are the modules in Power Center
What are pre and post-session shell commands?
How does the aggregator transformation handle null values?
What is the difference between stop and abort in informatica
what is the hint? how to use it to reduce the query processing in program?
Explain how to import oracle sequence into informatica?
lookup transformation with screenshots
What is meant by a domain?
How we can create indexes after completing the loan process?
What are the performance considerations when working with aggregator transformation?
what is diff b/t sorter t/r and agg have the option sorter property...