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,

1970

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

Wipro,

2 4809

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

Wipro,

2357

How to set Parameter in Script data source?

1 2407

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

Genpact,

1764

Unix command to view the data in a dataset

IBM,

2 6632

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 6575

what is the difference between repository & Intergration service

1 4607

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

SS Solutions,

1539

What is difference between merged dimension and forced dimension??

1 5086

What is ROWID explain ?

Wipro,

2 4815

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 3429

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 3720

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?

1767

Can we make worklet inside worklet?

1 6846

Un-Answered Questions { Data Warehouse }

What are batches?

1100

What is data validation strategies for data mart v?

1092

Explain reference cursor?

2167

What is tracing level and what are the types?

958

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

1026

How identifying bottlenecks in various components of informatica and resolving them?

1132

Can you explain a cognos controller?

1021

How can we do data cleaning?

1059

Differentiate between router and filter transformation?

1012

What is authentication? How many types of authentication.

915

How the users created differs from rpd/answers/dashboards level?

816

name the different procedures within ti?

What commands are used in the case of including or excluding any specific variables in the data set?

1097

Can decision tree be implemented using SQL?

2125

what is microstrategy narrowcast server?

1130

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