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
- 11723 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
Explain pushdown optimization $pushdownconfig parameter - informatica
What is lookup transformation?
What is workflow? What are the components of workflow manager?
What is a mapplet/worklet in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a joiner transformation and why it is an active one?
What are the different transaction levels available in transaction control transformation?
How can we use batches?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is meant by lookup transformation? Explain the types of lookup transformation?
What is mapplet in informatica?
what are the deliverables?in your project?
How can we update a record in the target table without using update strategy?
what are the Methods For Creating Reusable Transformations?
how we can load rejected record's at run time?(not through bad files)
