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...

source
file name xyz

a,0,a,a,a
b,b,b,0,b
c,c,c,0,c

target should be like this

xyz
a
b
c


how to implement this?

Answer Posted / rajesh

use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Data Caches size?

1086


Enlist the tasks for which source qualifier transformation is used.

1030


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1939


draw informatica architecture 8.6 ?

3868


Please let me know how to make Data masking in informatica..

1703


What are the uses of etl tools?

1121


As union transformation gives UNION ALL output, how you will get the UNION output?

1106


Explain about Informatica server process that how it works relates to mapping variables?

1064


Write the program through which the records can be updated?

998


Enterprise data warehouse your projects phase by phase explain?

1917


What is the reusable transformation?

1043


What all are steps in up gradation of Informatica server?

1042


Clarify the aggregator change?

1018


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1771


How can you increase the performance in joiner transformation?

1183