Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

How a source file is populated?

1023

What are the features of datastage flow designer?

1004

Can you explain tagbatch restructure operator?

1126

What is data partitioning?

1147

Can you explain kafka connector?

1254

What is the sortmerge collector?

1093

What is a datastage job?

973

How do you import and export data into datastage?

1186

Can you explain players in datastage?

1159

What is usage analysis in datastage?

1275

What is difference between symmetric multiprocessing and massive parallel processing?

1097

What is the project in datastage?

1062

What is ds designer?

1048

What is aggtorec restructure operator?

1368

Can you explain link buffering?

1117

Un-Answered Questions { Data Warehouse }

What you know about transaction control transformation?

953

Why managing the data is important?

974

Explain why dimenstion tables are denormalized in nature?

881

What are various warehousing tools?

932

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2590

Define datastores in cognos?

902

What data formats does Redshift Spectrum support?

which r the connectors used in san?

2152

What is embedded metric?

940

Describe the architecture of datastage?

969

What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.

2558

What do you understand by a term domain?

1083

What is the difference between server job and parallel jobs?

1104

AGGREGATOR default datatype

1403

What are the components of Informatica? And what is the purpose of each?

999

For More Un-Answered { Data Warehouse } Questions Click Here