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

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

2 Answers
5648 Views
BirlaSoft, I also Faced
E-Mail Answers

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