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
- 6716 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
Take col1 and col3 in pipeline with a sequece generator,
and sorted values of col 2 in another pipeline with
sequence generator. Join both pipelines by sequence values
and send it to target.
for more details.. look into 5th page, last question, last
answer
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / gd
sq-->Sorter t/r--->target
In sorter check the sorted port for col2 with ASC.
| Is This Answer Correct ? | 0 Yes | 2 No |
Where is metadata stored?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
how to get the first row without using rank t/r?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What do mean by local and global repository?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
How can you complete unrcoverable sessions?
what is degenerated dimension
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
What are the parts of Informatica Server?
What is the Difference between SetVariable and setmaxvariable in informatica?
Teradata 
