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
- 11951 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / jayachandra
use expression transformation here take two variable ports
one varaible port as v_sal and one more variable port as
o_sal and assign as o_sal=o_sal+sal
and write condition csum as
iif(sal=v_sal,o_sal+sal,o_sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
Have you worked with/created Parameter file
Where is metadata stored?
What is depict expression change?
r u done any partitions in ur project?
How to load a Dimension ? and how to load a fact table?
What is InformaticaPowerCenter?
difference between informatica 8.1.1 and 8.6
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is fact table? Explain the different kinds of facts.
Explain pushdown optimization and types in informatica
How an expression transformation differs from aggregator transformation?
What is a grid in Informatica?
How can we use mapping variables in informatica? Where do we use them?
What do you mean by blocking transformation?
