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


Please Help Members By Posting Answers For Below Questions

What are the different clients of powercenter?

602


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

3455


How can you define user defied event?

624


explain one complex mapping with logic? sales project?

6154


What is mapping debugger?

574






How you can differentiate between connected lookup and unconnected lookup?

617


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 ?

1906


What are the restrictions of union transformation?

581


How can we use mapping variables in informatica?

602


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

1417


What are active and passive transformations?

654


Can you use flat files in Mapplets.

2226


What all are steps in up gradation of Informatica server?

624


What is a sorter transformation?

665


How do you load first and last records into target table?

670