what is sql override?what is the use of it?
Answer Posted / chandumba2005
It is a process of defining the user defined SQL queries to filter data, joining the data ,sorting the data and eliminating duplicate records.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Differentiate between reusable transformation and mapplet.
Where is metadata stored?
Enlist some properties of sessions.
Is it possible to revert a global repository to local one and why?
Enlist the tasks for which source qualifier transformation is used.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is the -ve test case in your project.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the advantage of informatica?
How to update source definition?
What are the tasks that can be performed using sq?
How to do unit testing in informatica? How to load data in informatica ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How many numbers of sessions can one group in batches?