If u r giving different parameter file names in workflow and
session for a single mapping parameter, then which one will
be executed? The one u given in workflow or the one u given
in the session?
what is the dashbords?
What is fact table? Explain the different kinds of facts.
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
why we use source qualifier transformation?
what are the limitations of pushdown optimization technique ? Advance thanks
What is the difference between OLTP and ODS?
How to compare Source and Target table, without using dynamic lookup?
without matching columns in two tables. how can you join
What are the informatica performance improvement tips