Interested to Buy Any Domain ? << Click Here >> for more details...
i have 1000 record flat file source i want 1st row to 1st
target, 2nd row to 2nd target, 3rd row to 3rd target how will
u do? Without using Mod Function? Explain....
- 4 Answers
- 9835 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / davankumar
1st take squence t/t conn expresion t/r to one out put port.
In sequence t/r enable cycle option and start value is 1
end value is 3 and increment by 1.
then take rouder t/r in 1st group nextval/3=0 then 1st
target,nextval/3=1 then take 2nd target then connect to
default group ok.. r u clear...
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Mention a few design and development best practices for informatica?
How do you set a varible in incremental aggregation
What is a predefined event?
What is difference between a gateway node and worker node?
explain abt ur project architecture?
How can you increase the performance in joiner transformation?
What is dimensional table? Explain the different dimensions.
How can you generate reports in informatica?
What is informatica etl tool?
Can we get 1st record through Informatica(without sequence number).
Difference between Target-based loading and constraint-based loading?
How can informatica be used for an organization?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you load first and last records into target table?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
