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
- 11003 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Separate from a database, an information bazaar, and an information stockroom?
What is aggregate cache in aggregator transformation?
What are the features of complex mapping?
What is the need of etl tools?
Does an informatica transformation support only aggregate expressions?
What are the main issues while working with flat files as source and as targets ?
tell me the rules and responsblites in our project(my project is development)
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is a standalone command task?
What is the use of source qualifier?
What is an expression transformation in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is informatica etl tool?
What are the databases that informatica can connect to windows?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
