WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER?
chandumba2005@gmai.com
Answers were Sorted based on User's Feedback
Answer / srinivasulu raju
It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...
Condition: Source must be DataBase.
| Is This Answer Correct ? | 5 Yes | 0 No |
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
what is lookup ?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is source qualifier transformation in informatica?
what is constraint based loading
Can we create a Integration service without a Repository service and vice versa?
What do you understand by term role-playing dimension?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
How union transformation is active ?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Which gives the more performance when compare to fixed width and delimited file ? and why?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in