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 anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash

3 6688

What is the difference between Thin client & thick client?

5 28384

What is value prompt limitations while creating report? What is select and search prompt?

1 10979

what happens if cardinalities are not resolved?

PCS,

3 10008

Can anyone tell me the step by step process how to connect cognos to oracle?

3 7738

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2524

Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

2169

how many types transformations supported by sortedinput?

4 8392

what is lookupoverriding?

1 5874

How would you remove a format that has been permanently associated with a variable? ________________

Quintiles, TCS,

5 22113

what is the process of target load planing?

IBM,

2 6642

What is minimum version of internet explorer to run the Cognos report.

3 6720

What is the abrevation of .PPR? (Power play report) or anything new?

1 4295

what is the process we used in joiner transformation,there is no matching column in sources?

2 6866

what is the diff b/w union and joiner and lookup?

4 14622

Un-Answered Questions { Data Warehouse }

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

933

Explain fact structure?

986

What does reusable transformation mean?

1132

Which version configuration tool used in ur project?

3256

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2334

what is the use of server?

2196

explain about unit testing? in real time?

2205

Explain Dataware house architecture .how data flow from intial to end?

2583

How many numbers of sessions can one group in batches?

1064

describe the interaction table in sas di? : Sas-di

1031

What is a table alias in obiee 11g? Where and how will you create it?

1009

What are the string manipulation operators and functions associated with teradata?

1090

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1130

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1099

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