What are the informatica performance improvement tips

1152

What is Session and Batches?

1157

Explain what transformation and how many are there in informatica?

1034

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8313

Can informatica load heterogeneous targets from heterogeneous sources?

1239

What is a predefined event?

1137

what is INFORMATICA TESTING process

2335

Why union transformation is an active transformation?

1104

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2200

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1962

generate date / time dimension in informatica

1164

What are the different types of transformation available in informatica.

1149

Slowly changing dimensions, types and where will you use them

1774

What is the need for an etl tool?

1105

What is informatica? Why do we need it?

1166