which one is better either active or passive transformation
in informatica
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Explain how many types of dimensions are available in informatica?
What is meant by query override?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Define Update Override?
What are the types of presistent cache in look up tr.
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What is joiner cache?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Differentiate between sessions and batches?
what is filelist concept in informatica