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
- 7941 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
my source is junk data how will u remove that junk data by using unix please any one replay me
can you please explain me pre session and post session options?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
tell me the rules and responsblites in our project(my project is development)
Explain dynamic target flat file name generation in informatica
What is data movement mode in Informatica and difference between them?
What are the differences between a connected lookup and unconnected lookup?
Explain pushdown optimization and types in informatica
Explain target update override in informatica
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you promote a non-reusable transformation to reusable transformation?
Describe expression transformation?
What are the various types of transformation?
What is the need for an etl tool?
What are the new features of informatica 9.x in developer level?
