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
what are 3 tech challenges/ common issues you face?
Explain about cumulative Sum or moving sum?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How union transformation is used?
What are the guidelines to be followed while using union transformation?
Under what condition selecting sorted input in aggregator may fail the session?
What is informatica etl tool?
What is status code in informatica?
Under which circumstances, informatica server creates reject files?
How can we improve session performance in aggregator transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
In how many ways we can create ports?
Describe data concatenation?
Differentiate between sessions and batches?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.