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
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
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is Session and Batches?
What is a filter transformation?
To import the flat file definition into the designer where should the flat file be placed?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the advantages of informatica?
Is it possible to revert a global repository to local one and why?
Write the unconnected lookup syntax and how to return more than one column.
What is a predefined event?
Please let me know how to make Data masking in informatica..
What are the guidelines to be followed while using union transformation?
How many types of sessions are there in informatica.please explain them?
What is a pre-defined event and user-defined event?
What is a snowflake schema?