Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Define Routines and their types?
What are the types of views in datastage director?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Describe stream connector?
What is the difference between orabulk and bcp stages?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How the ipc stage work?
How to manage date conversion in Datastage?
Define data aggregation?
Explain the importance of surrogate key in data warehousing?
What are some prerequisites for datastage?
what is the use of materialized view?
why do u need the IOS upgradation in a FC switch