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
- 6487 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
have u done any performance tuning? how u ll do?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain how many types of dimensions are available in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is a mapplet/worklet in informatica?
Which are the different editions of informatica powercenter that are available?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Can we get 1st record through Informatica(without sequence number).
What are ETL Tools?
How to do unit testing in informatica?
What is aggregate cache in aggregator transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
How many numbers of sessions can one group in batches?
How will the document be delivered to me?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
