Interested to Buy Any Domain ? << Click Here >> for more details...
I have source like col1,col2,col3,col4 and the values are like
3,6,1,7
1,5,3,8
2,1,5,6
i want the output like
3,6,7
5,3,8
2,5,6
How we will achieve in this scenario in informatica level.
Please help me..
Thanks in advance..
- 4 Answers
- 8334 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / bharath
i don't know in informatica
in general approach,
concatenate all the columns into one column and strip the 1s
to empty string("")
and then seperate to each column one number on each column.
i hope it helps to u.
cheers!
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Different qualification between a related rotate toward the sky and isolates look upward?
Can anyone tell me the new features in Informatica 9 Version?
What is the difference between Active and Passive transformation?
How many transformations can be used in mapplets.
What is the benefit of session partitioning?
Where do we use mapping variables in informatica?
How will the document be delivered to me?
What is the commit type if you have a transaction control transformation in the mapping?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain lookup transformation in informatica
How is union transformation utilized?
can we override a native sql query within informatica? Where do we do it?
How can we store previous session logs?
What is difference between a gateway node and worker node?
Explain the different lookup methods used in informatica?
