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
- 6408 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 display First letter of Names in Caps?
What is router transformation
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
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?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is limitations of truncate and load option
What is powercenter on grid?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain pmcmd command usage in informatica
In which scenario did u used Mapping variable?
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
Teradata 
