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 am hvaing SOURCE as
1000,null,null,null
null,2000,null,null
null,null,3000,null
null,null,null,4000

Now i want the OUTPUT as

1000,2000,3000,4000

For more clarification i want to elimate nulls and want in
a single line.


Please help me out

Answer Posted / arunakumari l

let us take column names as col1,col2,col3,col4

STEP1:Add normalizer and place occurs value as 4

STEP2:use filter to eliminate null values

STEP3:take expression transformation and use concat
function to concatenate row values

i think this might work
tell me if i am wrong

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Implementation methodology

1654


What is workflow? What are the components of workflow manager?

1119


What is a dimensional model?

927


Where can we find the throughput option in informatica?

996


What is an unconnected transformation?

1033


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)

1556


Explain the aggregator transformation?

1093


Is it possible to revert a global repository to local one and why?

1023


Mention some types of transformation?

991


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

2468


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1000


What is dimensional table? Explain the different dimensions.

1110


What's the layout of parameter file (what does a parameter file contain?)?

2334


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1022


What is transformation?

1050