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..
- 4 Answers
- 7725 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / krishna prasad
use the filter transformation
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is the benefit of session partitioning?
What is the sequence generator transformation in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to load the data from a flat file into the target where the source flat file name changes daily?
Whats there in global repository
What is a standalone command task?
What is parallel processing in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is meant by incremental aggregation?
State the differences between sql override and lookup override?
What is the way to execute pl/sql script using informatica mapping?
What are the tuning techniques you applied during your last project
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the different lookup cache(s)?
