Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7010 Views
- KPIT, I also Faced
- E-Mail Answers
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 to go to the older version for a mapping?
According to his methodology what all you need before you build a datawarehouse
What is workflow monitor?
What's the layout of parameter file (what does a parameter file contain?)?
tell me the rules and responsblites in our project(my project is development)
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is domain and gateway node?
Have you worked with/created Parameter file
If informatica has its scheduler why using third party scheduler?
What are the types of caches in lookup?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are junk dimensions?
Global and Local shortcuts. Advantages.
What are the tasks that source qualifier perform?
differences between service based and product based?
