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
How do you take back up of repository?
What is informatica? Why do we need it?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is joiner transformation in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
What are multi-group transformations?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How might one distinguish in the case of mapping is right or not without associating session?
Why do we need informatica?
update strategy transformation in informatica
How can we remove the duplicates from flat file source?
Enlist few areas or real-time situations where informatica is required.
Explain what is informatica metadata and where is it stored?
Quickly characterize reusable change?
What are some examples of informatica etl programs?