Interested to Buy Any Domain ? << Click Here >> for more details...
I have source data like this
col1 col2 col3
5 3 8
6 2 9
7 1 10
and i want to get target as
col1 col2 col3
5 1 8
6 2 9
7 3 10
which transformation i have to use and how?
- 3 Answers
- 6366 Views
- I also Faced
- E-Mail Answers
Answer Posted / gd
sq-->Sorter t/r--->target
In sorter check the sorted port for col2 with ASC.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is Active lock explain
Why update strategy and union transformations are active? Explain with examples.
can u give example for factless fact table
Explain the aggregator transformation?
Explain scd type 3 through mapping.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the difference between a repository server and a powerhouse?
Explain constraint based loading in informatica
Explain what are the different types of transformation available in informatica.
What is target load order?
Suppose we do not group by on any ports of the aggregator what will be the output?
can we override a native sql query within informatica? How do we do it?
which one is better performance wise joiner or look up
Define joiner transformation?
What are the differences between a connected lookup and unconnected lookup?
