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
- 12129 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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Differentiate between joiner and lookup transformation?
If informatica has its scheduler why using third party scheduler?
What is confirmed fact in dataware housing?
what is degenerated dimension?
What are the static cache and dynamic cache in informatica?
What is joiner change?
What is incremental aggregation?
Differentiate between Load Manager and DTM?
How you know when to use a static cache and dynamic cache in lookup transformation?
what is the Default Source Option For Update Strategy Transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the prerequisite tasks to achieve the session partition?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is an expression transformation in informatica?
