Answer Posted / jvdwhinfo
Using incremental aggregation.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is a filter transformation and why it is an active one?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
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 are the issues you have faced in your project? How did you overcome those issues?
Is it possible to revert a global repository to local one and why?
Which development components of informatica have the highest usage?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to delete duplicate row using informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How many input parameters can exist in an unconnected lookup?
Explain the mapping variable usage example in informatica
What are active transformations.
Explain dynamic target flat file name generation in informatica
