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 calculate sum(sal) with out using aggregator satge

HSBC,

3 9507

what are the all possible features supported modify stage?

1 2263

i have one file i saved in csv how can i take these file into framework manager

1 2152

how to connect two or more table with single source qualifier?

IBM,

4 21122

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

TCS,

15 26806

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

IBM,

1 2556

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

TCS,

5 14687

HI, can anybody explain me how performence will decrease if we create objects using derived tables ?

2 5364

When we can use multiple sql statement for each measure? and multiple sql statement for each context?

2 14108

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 8764

Is it necessary to give joins to the aggrigate tables in the universe?

2 5484

On which column will you take primary index???

4 9212

how to import multiple flat files in to single target where there is no common column in the flat files

TCS,

2 7463

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 9715

is cognos 7 is better than cognos 8

TCS,

1 2226

Un-Answered Questions { Data Warehouse }

How to create the source and target database connections in server manager?

1144

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2549

Explain about a tricky situation for which you found a very simple solution?

1080

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1178

Have you have ever worked in unix environment and why it is useful in datastage?

1217

Demonstrate experience in maintaining quality process standards?

2675

What is the difference between business requirement document and use case document.

1086

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3446

what are the dimensions that you have in your current project?list them?

2095

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

847

What r the names of the reports that you prepared?

1032

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6077

how to generate the test data in sas without input data? : Sas-administrator

1207

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2095

Explain about a time when you discovered a more efficient way to do a work task?

1224

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