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 to create repository in abinitio for stand alone system(local nt)?

1225

How do you convert 4-way mfs to 8-way mfs?

1 3327

What is m_dump?

1236

How can you force the optimizer to use a particular index?

1061

Describe the grant/revoke ddl facility and how it is implemented?

1149

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

1141

What is the purpose of having stored procedures in a database?

1153

What is the difference between a scan component and a rollup component?

1192

Explain the difference between the truncate and delete commands?

1167

Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

1153

Can anyone give me an exaple of realtime start script in the graph?

1056

What is the difference between dml expression and xfr expression?

1095

How would you find out whether a sql query is using the indices you expect?

1070

What is $mpjret?

1152

How can I run the 2 gui merge files?

1179

Un-Answered Questions { Data Warehouse }

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1130

what is object level locking ? where do appear this type of locking ?

3501

What does Amp contain and what are all the operations that it performs?

1006

What is data stream and data adaopter. Is it same are different? Explain?

1014

Given an unsorted data set, how to read the last observation to a new data set?

1355

What is ab initio enterprise meta>environment (eme)?

1541

How to join 3 database like flat file, oracle, db2 in informatrica?

1240

What is crass reference table?

1055

Give an example where SAS fails to convert character value to numeric value automatically?

1090

What is thumbnail?

971

Define enterprise data warehousing?

1205

What is a macro routine?

2726

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4750

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2029

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3568

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