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

what is the difference between == and eq in UNIX shell scripting?

CTS,

1500

To see hidden files in LINIX?

CTS,

1527

sed,awk,head

CTS,

1463

How to read the length of word in unix?

CTS,

1380

options available in sequence job to run,validate?

CTS,

1316

What is the difference between validate and compile?

CTS,

1 4259

How to convert alpha Numeric values to alpha using functions?

CTS,

1 3096

what is the use of materialized view?

CTS,

1570

table actions available in oracle connector?

CTS,

1611

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

TCS,

1550

Can we get 1st record through Informatica(without sequence number).

1479

In Which Transformation We Can Use Having Clause In Informatica?

1242

Can you implement SCD2 using join, transformer and funnel stage?

Cognizant,

1557

In your project what type of issues and errors you facing in Teradata

iGate,

1 2320

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

Saama Tech,

1628

Un-Answered Questions { Data Warehouse }

Differentiate between proc means and proc summary.

1060

What are the different design perspectives used in teradata?

981

how to create reports on screech?

2554

What a datastage macro?

1059

What are the steps to create a data model?

1053

Within a cursor, how would you update fields on the row just fetched?

1070

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2444

Is union transormation is active transformation?

974

What are public objects?

1053

Explain the difference between keylokup and joiner?

891

Explain what is the extension of file to save template?

977

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3766

What is crass reference table?

1054

What are the functionalities of link partitioner and link collector?

1009

Define Routines and their types?

1185

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