How can we transform row to column?
In datastage can ve find the job based on source table name ??
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are the different methods of loading dimension tables?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
What needs to be done while starting the database?
Explain some of modeling tools available in the market?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What is meant by metadata in context of a data warehouse?
Advantages of de normalized data?
What is many-to-many dimensional model in datawarehousing ?
how to calculate sum(sal) with out using aggregator satge