Plz can anybody send Informatica and Cognos FAQ
Plz To thid ID ppradeep_dwh@yahoo.co.in
Answer Posted / qwer
Behave like a Dignified guy
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the different clients of powercenter?
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
How can you define user defied event?
explain one complex mapping with logic? sales project?
What is mapping debugger?
How you can differentiate between connected lookup and unconnected lookup?
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 are the restrictions of union transformation?
How can we use mapping variables in informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are active and passive transformations?
Can you use flat files in Mapplets.
What all are steps in up gradation of Informatica server?
What is a sorter transformation?
How do you load first and last records into target table?