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,

1 1583

To see hidden files in LINIX?

CTS,

1 1627

sed,awk,head

CTS,

1 1521

How to read the length of word in unix?

CTS,

1 1446

options available in sequence job to run,validate?

CTS,

1 1386

What is the difference between validate and compile?

CTS,

1 4417

How to convert alpha Numeric values to alpha using functions?

CTS,

1 3220

what is the use of materialized view?

CTS,

1 1677

table actions available in oracle connector?

CTS,

1 1679

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,

1 1625

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

1 1547

In Which Transformation We Can Use Having Clause In Informatica?

1 1317

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

Cognizant,

1 1619

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

iGate,

1 2424

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,

1 1702

Un-Answered Questions { Data Warehouse }

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

2093

Write the unconnected lookup syntax and how to return more than one column.

1174

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1042

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

What is node? How many nodes and amps used in your previous project?

1173

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2175

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2492

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792

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

1144

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2436

What sort of existing documents should business analysts refer to when starting on a new project?

1078

Write the unconnected lookup syntax?

1146

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

1202

What is dimensional table?

1162

what is document design in boxi,have u participate in that

2305

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