Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 6532 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What are the types of groups in Router transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
What is flashback table ? Advance thanks
Explain sessions and how many types of sessions are there?
how we can load rejected record's at run time?(not through bad files)
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
What are the types of maping in Getting Started Wizard?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
How might one distinguish in the case of mapping is right or not without associating session?
What is predefined event?
Teradata 
