Name at least 5 different types of transformations used in mapping design and state the use of each.?

1152

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1958

What do you mean by channel change?

1039

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1078

Explain target update override in informatica

1122

How to update source definition?

1082

Is stop and abort are same in informatica?

995

Quickly characterize reusable change?

1117

What are the transformations that are not supported in mapplet?

1019

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

1855

Target increases every day even though no new record was inserted

1570

what is index?how it can work in informatica

2038

Explain in detail scd type 2 through mapping.

1039

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2160

State the limitations where we cannot use joiner in the mapping pipeline?

1060