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
- 8658 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
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is sequence generator transformation in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain Dataware house architecture .how data flow from intial to end?
tell me the rules and responsblites in our project(my project is development)
When do you use sql override in a lookup transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the types of lookup transformation?
What is the status code in stored procedure transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Define enterprise data warehousing?
what is degenerated dimension?
How might one distinguish in the case of mapping is right or not without associating session?
How to generate sequence numbers without using the sequence generator transformation?
