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..
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
How to use procedural logic inside infromatica?
What is flashback table ? Advance thanks
Explain the shared cache and re-cache?
What is the status code in stored procedure transformation?
can u give example for factless fact table
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How can we handle two sessions in informatica?
where to store informatica rejected data?
How can informatica be used for an organization?
What does reusable transformation mean?
How to do the error handling of if ur source is flatfiles?
is it possible to index the data in cache of lkp transformation ?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain lookup transformation source types in informatica
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com