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

For clinical entire study how many tables will create approx?

TCS,

1974

How to read data from flat file source if the data is in paragraph format?

Wipro,

2 4819

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

Wipro,

2362

How to set Parameter in Script data source?

1 2415

How to create a cube in Transformer? What is the process? Please mention process thank u

Genpact,

1770

Unix command to view the data in a dataset

IBM,

2 6638

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

IBM, PR3 Systems,

4 6589

what is the difference between repository & Intergration service

1 4616

hoe to access second value in mapping parameter if it is having more than one value ?????????????

SS Solutions,

1547

What is difference between merged dimension and forced dimension??

1 5095

What is ROWID explain ?

Wipro,

2 4830

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 3435

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 3728

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1774

Can we make worklet inside worklet?

1 6856

Un-Answered Questions { Data Warehouse }

What is the difference between %local and %global? : sas-macro

1192

U r project in which stage in implementation?

2526

What are the stages of datawarehousing?

1015

what are the types of interactive display types? : Sas-bi

1100

Explain what are the different types of join operations?

973

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1880

Whether dimension table can have numeric value?

1159

how would u estimate the size of Aggregator transform data and index cache?

2416

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2499

Mention what is abinitio?

999

Explain what are slowly changing dimensions?

1029

What is a security filter in microstrategy?

1029

What is a deadlock and how it occurs?

1167

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

837

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1881

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