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

Mention what are the data types does SAS contain?

1203

Can we create multiple integration service on single repository?

1245

How would you join a node to the already existing domain?

1190

What is primary and backup node?

1185

Define pmcmd command?

1117

How to go to the older version for a mapping?

1172

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 1973

What is meant by LDAP users?

1299

What is a shortcut and copy in Informatica and how two are different with each other?

1255

What is exclusive and normal mode for repository services?

1199

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1224

What is a grid in Informatica?

1126

Can we create a Integration service without a Repository service and vice versa?

1260

What is deployment group?

1311

What are roles and groups and benefits of using them?

1120

Un-Answered Questions { Data Warehouse }

How will you create interactive dashboards ?

955

What are the multiload utility limitations?

1121

what is sas metadata server? : Sas-di

1167

What is a cube in data warehousing concept?

1150

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1078

What are the batches and it’s details?

1031

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2098

What would be the value of month at the end of data step execution and how many observations would be there?

1240

Mention few capabilities of sas framework.

1258

Explain different types of partitioning?

1099

Can intelligence server integrate with my existing data structure?

1130

What is difference between symmetric multiprocessing and massive parallel processing?

1205

What is a grid in Informatica?

1126

Explain what is the metadata extension?

1110

How can we remove the duplicates from flat file source?

1083

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