Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What is repository manager?

933


What is joiner transformation?

951


Explain sessions. Explain how batches are used to combine executions?

955


Separate from a database, an information bazaar, and an information stockroom?

1015


Tell me about MD5 functions in informatica

878


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1104


In informatics server which files are created during the session rums?

1067


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1807


What are multi-group transformations?

1013


How would you copy the content of one repository to another repository?

952


What is the sql query overwrite in source qualifier in informatica

1029


What is the reusable transformation?

1008


How can we use mapping variables in informatica?

1004


What is informatica?

1080


COM components can be used in Informatica

2315