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
- 10718 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / kriishh
take SQ->EXP.In expression create a variable port
V_CUM_SAL=V_CUM_SAL+SAL
then create a new o/p port o_sal=V_CUM_SAL
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Why update strategy and union transformations are active? Explain with examples.
What are the uses of etl tools?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Enlist the various types of transformations.
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 parallel processing in informatica?
Differences between version 7.x and 8.x.
How might one distinguish in the case of mapping is right or not without associating session?
How can we use batches?
What is the need of an ETL tool?
To import the flat file definition into the designer where should the flat file be placed?
What are Dimensional table?
Performance tuning( what you did in performance tuning)
What are the new features of informatica 9.x in developer level?
