my source is like this id,name sal 10 abc 1000,10 pqr 2000,
10 xyz 3000 ,10 jkl 4000 and my requirement is like this
10 abc,pqr,xyz,jkl 2000 ....
i have try for this by using expression transformatin its ok
of the concatenation of second column but the thing is that
on third column if u group by using agg t/r the last value
will com i.e 4000 but i asked by a interviewer that i dont
want the first or last column i want the middle column i.e
2000 .plz reply for the same
Answer Posted / babu
Sorry to all,
Above answer is have small correction theat is very
difficult to explain here.
i will give one more solution, it is very simple
Mapping:
=======
SEQ
||
SRC=>SQ=>EXP=>AGGR(NOGROUPBY)=>TG1(ID,NAME)
||
EXP=======================FLT==TG2(SAL)
SQ::SELECT A.ID,A.NAME,A.SAL,(SELECT COUNT(ID) FROM TABLE
T) CNO FROM TABLE T
EXP::SNO(NEXTVALPORT) From Sequence generator
ID <input>
NAME <input>
O_NAME=(IIF(ID=V_ID,V_NAME||' ,'||NAME,NAME)) <Oport>
V_ID=ID <Variablr Port>
V_NAME=NAME <Variable Port>
SAL <I&O>
CNO
FLT:: SNO=CNO/2 RETURN SAL
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How you know when to use a static cache and dynamic cache in lookup transformation?
explain about unit testing? in real time?
How do you load unique records into one target table and duplicate records into a different target table?
How can we use mapping variables in informatica?
Can we create two repositories on same database instance in oracle?
Where is metadata stored?
How does the aggregator transformation handle null values?
Explain lookup transformation in informatica
What is Session and Batches?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
where to store informatica rejected data? How to extract the informatica rejected data?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What do you mean by filter transformation?
What are the issues you have faced in your project? How did you overcome those issues?