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 9270

what are the all possible features supported modify stage?

2138

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

2083

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

IBM,

4 20949

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 26072

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,

2500

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 14342

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

2 5218

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

2 13988

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

4 8498

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

2 5295

On which column will you take primary index???

4 8996

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

TCS,

2 7322

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

1 9603

is cognos 7 is better than cognos 8

TCS,

2165

Un-Answered Questions { Data Warehouse }

What are constraints and derivations?

1170

Write the program through which the records can be updated?

1006

What are the scenarios in which full table scans occurs?

1010

What is main difference mapplets and mapping?

1196

What is the project in datastage?

1114

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

963

define sparse cube?

Does Amazon redshift based on concept cluster?

Explain pmcmd command usage in informatica

1136

What do you mean by derived metrics?

996

What can be achieved by using the teradata rdbms?

1038

What are the new features included in the new version of SAS Programming Language?

1210

where to use sas business intelligence? : Sas-bi

1091

How many transformations can be used in mapplets.

1935

what are the types in error loging?

2151

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