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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

I am hvaing SOURCE as first line: 1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
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

Question Posted / honeybint

Answers were Sorted based on User's Feedback



I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd li..

Answer / durgaprasad

select no,max(col1),max(col2),max(col3),max(col4) from
tablename group by no;

Is This Answer Correct ?    7 Yes 0 No

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd li..

Answer / srinivas

Just load the flat file.
(1000,null,null,null
null,2000,null,null
null,null,,3000,null
null,null,null,4000)
Go with Aggregate Trans formation with
MAX(field1)
MAX(field2),,,, .

Pls let me know if any corrections srinu.srinuvas@gmail.com

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More Informatica Interview Questions

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

What is exclusive and normal mode for repository services?

0 Answers  

what are the row and column separations in Flat Files

3 Answers   CTS,

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

Explain incremental aggregation in informatica

0 Answers   Informatica,

What is an Integration service in Informatica?

0 Answers  

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

can we use cartesian join in informatica

3 Answers   IBM,

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

For more Informatica Interview Questions Click Here
Categories