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
- 10585 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
What do you mean incremental aggregation?
What is option by which we can run all the sessions in a batch simultaneously?
What is DR strategy for Informatica project?
What is the difference between a connected look up and unconnected lookup?
What does cheating measurement mean?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Did u used latest transformations of 8.6.0? for what?
What do you mean by worklet?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain the different kinds of facts.
What is meant by LDAP users?
What is the function of look up transformation?
What is pmcmd command?
What are the databases that informatica can connect to windows?
Make a note of the quantity vaults made in informatica?
