Interested to Buy Any Domain ? << Click Here >> for more details...
SOURCE
1 a
1 b
1 c
2 a
2 b
2 c
TARGET
1 A B C
2 A B C
In oracle & informatica level how to achieve
- 4 Answers
- 7824 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / mr.lee
Hi,
Using Informatica
SRC-SQ-SRT(key used id)-EXP(
v_name = IIF(ID=v_prev_id,v_prev_name ||'
'||UPPER(name),UPPER(name))
v_prev_name = v_name
out_name = v_prev_name
v_prev_id = ID
)-AGG(group by id will give u last row)-TGT
Ankit Kansal
This is wrong Concept....
First Try You
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
can we override a native sql query within informatica? How do we do it?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is sorter transformation?
What is union transformation in informatica?
Name the different lookup cache(s)?
update strategy transformation in informatica
How do you update the records with or without using update strategy?
While migrating the data from one environment to another environment how would you manage the connections?
How to use pmcmd utility command?
What is the use of source qualifier?
Informatica settings are available in which file?
what are 3 tech challenges/ common issues you face?
