I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
5 10270Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
10 19991my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
10 18968in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
2 10005Post New Informatica Questions
How can we handle two sessions in informatica?
What are the performance considerations when working with aggregator transformation?
What do you mean by channel change?
What is data movement mode in Informatica and difference between them?
What is pmcmd command?
differences between service based and product based?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the use of an aggregator cache file?
Explain what transformation and how many are there in informatica?
Implementation methodology
What is meant by lookup transformation?
Write the unconnected lookup syntax and how to return more than one column.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a predefined event?
What happens when a session fails and you click on recover?