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.
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 |
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
when we dont use aggregator in mapping ?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
How do we call shell scripts from informatica?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
when informatica 8 series released ?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
How to load last 10 records of flat file in to the target?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??