1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / debasis_49

Answers were Sorted based on User's Feedback



My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

Answer / siva

In expression add one column and make it output(sal1) and
salary port as input only.
We will make use of a function named cume(salary) to solve
our problem, rather using any complex mapping

Is This Answer Correct ?    15 Yes 0 No

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

Answer / nirosha g

Use Expression Transformation for this.
Create variable port after the two input ports:
v_cumm_sal = v_cumm_sal+sal;
o_cumm_sal = v_cumm_sal;

Connect The ports id,sal and o_cumm_sal to target

Is This Answer Correct ?    5 Yes 0 No

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

Answer / suresh

we have a predefined function in informatica CUME()
in expression t/r. donot struggle for writing logics

Is This Answer Correct ?    4 Yes 0 No

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

Answer / 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

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following E..

Answer / 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

More Informatica Interview Questions

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

What is the difference b/w natural key and surrogate key

1 Answers  

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

how will you get 21 to 30 record from 50 records?

6 Answers  

Why is sorter an active transformation?

0 Answers  




What is the difference Between Mapping parameter and variable

3 Answers   Accenture,

What is the fact table?

0 Answers  

Enlist the differences between database and data warehouse.

0 Answers  

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

For more Informatica Interview Questions Click Here
Categories