Answer Posted / srinivas
there are four types of joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what is the Default Source Option For Update Strategy Transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are pre and post-session shell commands?
How do you handle two sessions in Informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is target load order?
what is the difference between informatica6.1 and infomatica7.1
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is pmcmd command?
What is meant by incremental aggregation?
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 enterprise data warehousing?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How do you manage the Parameter files while migrating your data from one environment to another environment?
