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
What is domain and gateway node?
What are the features of complex mapping?
Explain the features of connected and unconnected lookup.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a router transformation?
What is enterprise data warehousing?
Slowly changing dimensions, types and where will you use them
How many ways are there to create ports?
what is mean by complex business rule ?
How are indexes created after completing the load process?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the prerequisite tasks to achieve the session partition?
Clarify the utilization of aggregator cache record?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Mention some types of transformation?