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
- 5717 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 |
How to recover the standalone session?
How u use pdf file in informatica source?
how can i invoke pmcmd in command line prompt
Is it possible to define a single node as a Gateway node as well as worker node?
How to load the data from a flat file into the target where the source flat file name changes daily?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
How to delete duplicate records in a flat file source?
What is a filter transformation?
How does a rank transform differ from aggregator transform functions max and min?
When do you use sql override in a lookup transformation?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
where is the reject loader .
Teradata 
