I have source like col1,col2,col3,col4 and the values are like
3,6,1,7
1,5,3,8
2,1,5,6
i want the output like
3,6,7
5,3,8
2,5,6
How we will achieve in this scenario in informatica level.
Please help me..
Thanks in advance..
Answer Posted / krishna prasad
use the filter transformation
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
On which transformations you created partitions in your project?
What happens when a session fails and you click on recover?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
can u give example for factless fact table
What is a dimensional model?
Explain the mapping variable usage example in informatica
How do you change a non-reusable transformation to reusable transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How can we improve session performance in aggregator transformation?
What is the advantage of informatica?
How many ways are there to do 'remove duplicate records in informatica'?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is data movement mode in Informatica and difference between them?