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

I want skip first 5 rows to load in to target? what will be the logic at session level ??

IBM,

1 7091

Demonstrate experience in maintaining quality process standards?

iGate,

2560

How to get the repeated values by using sql in sas ?

2 5673

What is factless fact schema?

3 7260

Difference between Teradata V2R5 and Teradata V12 versions?

IBM,

2 8445

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

IBM, TCS,

7 10883

Hi, How to navigate one report to another report in webi? Thanks in Advance

3 8650

How do you eliminate duplicates?

3 8129

how can u find out the datastage job is running on how many nodes

IBM,

7 23095

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

Quintiles,

9 13074

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 4270

can you apply grouping on crosstab?

CTS,

1 6770

if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

CTS,

2 8813

how to convert crosstab into list?

TCS,

4 9883

data import to models, datastores,stored processed, is there any other way to import data?

TCS,

1 4298

Un-Answered Questions { Data Warehouse }

What are default access rights in teradata?

1128

What are the steps required to kill the job in Datastage?

1218

What parallelisms does Abinitio support?

1211

Explain about Informatica server process that how it works relates to mapping variables?

1089

What are the repository tables in datastage?

1309

EXL informatica Questions

1396

What is rank transform?

1003

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1065

How to extract sap data using informatica? What is abap? What are idocs?

1185

How might one distinguish in the case of mapping is right or not without associating session?

1131

Give some difference between oltp and olap.

1013

Differentiate primary key and partition key?

986

What is Analysis Services?

2149

What is primary and backup node?

1137

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

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