ETL tool is ment for extraction data from the legecy systems and load into specified data base with some process of cleansing data.
ex: Informatica,data stage ....etc
OLAP is ment for Reporting purpose.in OLAP data avaliable in Mulitidimectional model. so that u can write smple query to extract data fro the data base.
ex: Businee objects,Cognos....etc
What is the Rankindex in Ranktransformation?
How to improve session performance in aggregator transformation?
What is the difference between connected and unconnected stored procedures?
What is the difference between Narmal load and Bulk load?
What is source qualifier transformation?
Is union Transormation is Active transformation?
What are variable ports and list two situations when they can be used?
How to import VSAM files from source to target. Do we need a special plugin?
How many types of facts and what are they?
What is Load Manager?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
