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
- 11719 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 is the difference between informatica 7.0 and 8.0?
How can we delete duplicate rows from flat files?
What is a surrogate key?
Explain about Informatica server process that how it works relates to mapping variables?
Explain the different kinds of facts.
Explain how many types of dimensions are available in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
hi real timers . iam waiting for ur reply regarding ETL TESTING
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to update a particular record in target with out running whole workflow?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is parallel processing in informatica?
How can repository reports be accessed without sql or other transformations?
What is the difference between informatics 7x and 8x and what is latest version?
What is exclusive and normal mode for repository services?
