My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000).
In the Target I want the following EmpID, Salary,
Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103,
3000, 6000). Please guide on how to build the mapping.
Answer Posted / rambhupal
by using variable port also we can solve this.create one variable port and output port,assign that v_count=v_count+salary,for out port o_count=v_count
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x in developer level?
What are data-driven sessions?
Did u used latest transformations of 8.6.0? for what?
Make a note of the quantity vaults made in informatica?
What is intricate mapping?
What are mapplets?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain sessions. Explain how batches are used to combine executions?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How many ways are there to create ports?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is fact table? Explain the different kinds of facts.
Implementation methodology
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
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