1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2512

When and why we should use Redshift Spectrum?

5

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

920

What are the different types of olap? Give an example?

976

Mention some ways for improving performance of a graph?

1045

What is the difference in creating filters in designer and business objects?

978

What is the difference between nodupkey and nodup options?

974

According to his methodology what all you need before you build a datawarehouse

1692

Why facts table is useful in representing the data?

931

What is the Rank index port in Rank transformation?

1015

Define project in datastage?

1052

Have you used Unstructured data?

1269

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

895

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2354

Why is auto-regression used in forecasting used on cognos platform?

952