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
- 8375 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
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the surrogate key?
what is the difference between informatica6.1 and infomatica7.1
How to open an older version of an object in the workspace?
Sequence generator, when you move from develoment to production how will you reset
What are the components of workflow manager?
Enlist the advantages of informatica.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is dynamic cache?
What can we do to improve the performance of informatica aggregator transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How can you increase the performance in joiner transformation?
Explain the difference between mapping parameter and mapping variable?
What is pmcmd command?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
