Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 10796 Views
- Polaris, I also Faced
- E-Mail Answers
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
Can informatica load heterogeneous targets from heterogeneous sources?
What is primary and backup node?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is parallel processing in informatica?
Enlist few areas or real-time situations where informatica is required.
What is an Integration service in Informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is informatica?
What are the popular informatica products?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How do you use reject loader.
Explain lookup transformation is active in informatica
What is aggregator transformation in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
