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
- 7768 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
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
scenario where i can use only concurrent execution of workflow.
server hot-ws270 is connect to Repository B. What does it mean?
What are the limitations of joiner transformation?
Why is sorter an active transformation?
What does reusable transformation mean?
What are the differences between a connected lookup and unconnected lookup?
In informatica workflow manager, how many repositories can be created?
where to store informatica rejected data? How to extract the informatica rejected data?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what is Active lock explain
What are the components of the workflow manager?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is blocking transformation?
