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
- 11235 Views
- Amdocs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / priyank
Var_SAL=IIF(Var_SAL=0,SAL,Var_SAL+SAL)
Out_SAL=Var_SAL
| Is This Answer Correct ? | 1 Yes | 0 No |
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
Make a note of the quantity vaults made in informatica?
How do we call shell scripts from informatica?
COM components can be used in Informatica
we have to use order by,where,having we to implement sql query
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
Enlist the various types of transformations.
How to Create a folder using pmrep command?
Teradata 
