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

My source table look like
ID Name Location Salary
1 ran NULL NULL
1 NULL DELHI NULL
1 NULL NULL 1000

I want my output to look like

ID Name Location Salary
1 ran Delhi 1000

What should be my approach to design a informatica mapping.
Assuming my source is flat file not a Relation table so i
cant use SQL.

Question Posted / dharmendra13singh

Answers were Sorted based on User's Feedback



My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELH..

Answer / abhishek kumar

In aggregator
id group by;
o_name -> max(name);
o_location-> max(location);
o_salary-> max(salary);

connect id to id(target),o_name to name(target),o_location
to location(target),o_salary to salary(target) port;
src->sq->aggregator->target

Is This Answer Correct ?    13 Yes 1 No

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELH..

Answer / rajan raorane

Use the below Mapping


Flat file-->SRC Qualif-->EXp-->Filter( With not null
condition on each port)-->Normalizer-->output

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Explain in detail scd type 2 through mapping.

0 Answers  

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

What you know about transaction control transformation?

0 Answers  

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,




TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

How do you set a varible in incremental aggregation

0 Answers  

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

what is metadata?

8 Answers   Satyam,

What is IQD file?

1 Answers  

For more Informatica Interview Questions Click Here
Categories