Interested to Buy Any Domain ? << Click Here >> for more details...
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
- 5 Answers
- 12130 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / kriishh
take SQ->EXP.In expression create a variable port
V_CUM_SAL=V_CUM_SAL+SAL
then create a new o/p port o_sal=V_CUM_SAL
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What are the main features of Oracle 8i with context to datawarehouse?
Target increases every day even though no new record was inserted
Informatica settings are available in which file?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the data movement modes in informatica?
How we can use union transformation?
How to update a particular record in target with out running whole workflow?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What all are steps in up gradation of Informatica server?
What is powercenter on grid?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What does role playing dimension mean?
Write the advantages of partitioning a session?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
