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
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
can we override a native sql query within informatica? Where do we do it?
what is Active lock explain
How to improve the performance of a session using sorter transformation?
Write the different tools in the workflow manager?
How can a transformation be made reusable?
How can we update a record in the target table without using update strategy?
What is dynamic cache?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How would you join a node to the already existing domain?
what is INFORMATICA TESTING process
What is Session and Batches?
What are the tasks that source qualifier perform?
What are the informatica performance improvement tips
What are connected or unconnected transformations?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.