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
How to join three sources using joiner? Explain though mapping flow.
have u done any performance tuning? how u ll do?
Explain about Informatica server process that how it works relates to mapping variables?
How can we store previous session logs?
What could be the possible resons of locks by user?
What are the prerequisite tasks to achieve the session partition?
What are pre and post-session shell commands?
explain about unit testing? in real time?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the format of informatica objects in a repository?
Describe the impact of several join conditions and join order in a joiner transformation?
Define enterprise data warehousing?
Where do we use mapping variables in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
tell me about your project functionality