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
- 8488 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
in reporting we add some new objects,how we get the count of the newly added objects to the report
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Enlist few areas or real-time situations where informatica is required.
Where is metadata stored?
What is primary and backup node?
What is the scenario which compels informatica server to reject files?
How many ways a relational source definition can be updated and what are they?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the different lookup cache(s)?
What is lookup change?
What if the source is a flat-file?
What is the difference between a repository server and a powerhouse?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the use of an aggregator cache file?
