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
- 8001 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
Explain in detail scd type 2 through mapping.
What is fact table? Explain the different kinds of facts.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to use pmcmd utility command?
What are the data movement modes in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the types of presistent cache in look up tr.
server hot-ws270 is connect to Repository B. What does it mean?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What does refresh system mean, and what are its distinctive choice?
how tokens will generate?
What are the mapping parameters and mapping variables?
tell me the rules and responsblites in our project(my project is development)
What is a difference between complete, stop and abort?
How can we delete duplicate rows from flat files?
