Which transformation should we use to normalise the COBOL and relational sources?

1216

How do you change a non-reusable transformation to reusable transformation?

1002

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2032

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

1213

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1637

How to create a non-reusable instance of reusable transformations?

1135

How can we update a record in the target table without using update strategy?

1152

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1497

Differentiate between Load Manager and DTM?

2160

can anyone suggest best free Talend data integration training online

1696

What is the difference between router and filter?

1276

Briefly explain the aggregator transformation?

1015

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

1867

Explain the types of transformations?

1073

How to load a Dimension ? and how to load a fact table?

1423