Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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..




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


Please Help Members By Posting Answers For Below Questions

How to use procedural logic inside infromatica?

1249


What is flashback table ? Advance thanks

1944


Explain the shared cache and re-cache?

1124


What is the status code in stored procedure transformation?

1185


can u give example for factless fact table

6662


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2525


How can we handle two sessions in informatica?

1038


where to store informatica rejected data?

1100


How can informatica be used for an organization?

1221


What does reusable transformation mean?

1142


How to do the error handling of if ur source is flatfiles?

1972


is it possible to index the data in cache of lkp transformation ?

2033


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

2346


Explain lookup transformation source types in informatica

1105


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

4732