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

Can you copy the session to a different folder or repository?

1 6726

What is batch and describe about types of batches?

2 12344

Can you copy the batches?

3 10807

How many number of sessions that u can create in a batch?

3 10622

When the informatica server marks that a batch is failed?

2 6801

What is a command that used to run a batch?

4 12271

What are the different options used to configure the sequential batches?

Wipro,

2 9365

In a sequential batch can u run the session if previous session fails?

3 7175

Can you start a batches with in a batch?

1 6255

Can you start a session inside a batch individually?

2 9388

How can u stop a batch?

2 7061

What are the session parameters?

3 15352

What is parameter file?

2 6896

How can you access the remote source into your session?

1 6349

What is difference between partioning of relatonal target and partitioning of file targets?

2 13978

Un-Answered Questions { Data Warehouse }

What is bteq script in teradata?

1221

Explain access control?

1066

explain in detail about type 3?

1074

In Which Transformation We Can Use Having Clause In Informatica?

1300

What is the fact table?

1145

how u will design the report if the objects are available

2809

What is Discover and Execute in XMLA?

2470

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5886

EXL informatica Questions

1451

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2668

What is the difference between olap and oltp?

1139

Can intelligence server integrate with my existing data structure?

1124

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

Can you execute macro within another macro? : sas-macro

1052

What are the different etl testing categories as per their function?

1154

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