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
- 10716 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sameer
First we uses cumulative function and second we can use expression transformation then we can calculate
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Session and Batches?
Why filter transformation is an active one?
Can you generate sequence numbers without using the sequence generator transformation?
What is workflow? What are the components of the workflow manager?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the settings that you use to configure the joiner transformation?
What is the difference between a connected look up and unconnected lookup?
What are the different options available for update strategy?
What is joiner transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the scenario which compels informatica server to reject files?
Explain the types of lookup transformation?
can we override a native sql query within informatica? Where do we do it?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is union transformation in informatica?
