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
without table how to come first record only in oracle?
Define enterprise data warehousing?
What is transformation?
Differences between connected and unconnected lookup?
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.
what is the -ve test case in your project.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are multi-group transformations?
tell me the rules and responsblites in our project(my project is development)
How do you set a varible in incremental aggregation
how tokens will generate?
What is the benefit of session partitioning?
How can we improve session performance in aggregator transformation?
Plz can any one say me how to get the informatica certification materials and dumps
What is workflow? What are the components of the workflow manager?