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
- 11959 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
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are ETL Tools?
Difference between Data and Index Caches?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is source qualifier transformation in informatica?
What is the Rank index port in Rank transformation?
What is update strategy transform?
what is the complex transformation you used in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is intricate mapping?
What do you understand by term role-playing dimension?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain pushdown optimization and types in informatica
What are the modules in Power Center
