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
- 7181 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
How to extract sap data using informatica?
Can we create two repositories on same database instance in oracle?
How we can use union transformation?
What is data transformation manager process?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a transaction control transformation?
Define Pmrep command?
What is lookup change?
What are the tasks that source qualifier perform?
What do you mean by blocking transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to load a Dimension ? and how to load a fact table?
Differentiate between sessions and batches?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
