Mention a few design and development best practices for informatica?

1047

EXL informatica Questions

1448

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

1911

How does a rank transform differ from aggregator transform functions max and min?

1263

What are the performance considerations when working with aggregator transformation?

1212

Explain the etl program with few examples.

1115

In informatics server which files are created during the session rums?

1171

What is a standalone command task?

1256

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7506

What is workflow? What are the components of workflow manager?

1235

How do you update the records with or without using update strategy?

1164

Under what condition selecting sorted input in aggregator may fail the session?

1176

What is informatica worklet?

1118

Explain pushdown optimization and types in informatica

1123

What is depict expression change?

1200