WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER?
chandumba2005@gmai.com
Answer Posted / 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 |
Post New Answer View All Answers
What is Cognos script editor?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
can you please explain me pre session and post session options?
What do you mean by channel change?
During the running session, output files are created by informatica server. Enlist few of them.
Where is metadata stored?
Differentiate between sessions and batches?
Explain about Informatica server process that how it works relates to mapping variables?
How do you update the records with or without using update strategy?
What is the fact table?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
State the limitations where we cannot use joiner in the mapping pipeline?
Difference between Data and Index Caches?
What is the advantage of informatica?