i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Answer Posted / sameer
First we uses cumulative function and second we can use expression transformation then we can calculate
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
tell me the rules and responsblites in our project(my project is development)
Performance tuning( what you did in performance tuning)
Define sessions in informatica etl?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the fact table?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded 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
Why do you use Mapping Parameter and mapping variable?
What are the measure objects?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to use procedural logic inside infromatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are ETL Tools?