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
- 11942 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
explain abt ur project architecture?
What are the different lookup cache(s)?
Why do you use Mapping Parameter and mapping variable?
What are the informatica performance improvement tips
Enlist the various types of transformations.
What are the uses of etl tools?
How can we use batches?
is it possible to index the data in cache of lkp transformation ?
Explain about Informatica server process that how it works relates to mapping variables?
What are the main issues while working with flat files as source and as targets ?
What is parallel processing in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is depict expression change?
what is informatica metadata?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
