Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 11229 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / priyank
Var_SAL=IIF(Var_SAL=0,SAL,Var_SAL+SAL)
Out_SAL=Var_SAL
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is mapping debugger?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is a rank transform?
What are the various types of transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Different qualification between a related rotate toward the sky and isolates look upward?
How can we update a record in the target table without using update strategy?
How to generate sequence numbers without using the sequence generator transformation?
What are the tasks that source qualifier perform?
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?
Differentiate between joiner and lookup transformation?
How to elaborate tracing level?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
how to load dimension table and fact table. plz tell me the steps.
