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
Define the various join types of joiner transformation?
What is a transaction control transformation?
what is the size of u r source(like file or table)?
As union transformation gives UNION ALL output, how you will get the UNION output?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
what is the Default Source Option For Update Strategy Transformation?
In warehouses how many schemas are there?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What do you understand by a term domain?
What is the function of union transformation?
What is deployment group?
What is informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the need of an ETL tool?
How do you load first and last records into target table?