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 have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

DELL,

2 7538

difference between informatica 8.6 and 9

Atos Origin, BA Continnum Solutions, Core Logic,

3 44238

What are the different types of OLAP. Which one is Cognos Powercube?

HSBC,

2 7157

How can I remove header from output data set?

2666

1.what is activity count? 2.what is skew factor? how it's working explain brefily

Satyam,

5 33102

What is the diff between abinitiorc and .abinitiorc files ?

IBM, Infosys, TCL,

1 26713

11. What is the use of allocate()?

TCL,

1 5661

. What is dynamic lookup ?

CTS,

1 13232

What is regex (lookup)? When you should use it?

HCL,

3 15869

Why creation of temporary files depends on the value of MAX CORE

HCL,

1 6156

What is dependent parameter ?

HCL,

1 7105

What is the significance of record required indicator of Join component ?

HCL,

1 8210

. What is flow buffering ? How it reduces the chances of having deadlock ?

HCL,

1 7883

When we should use 'jobid' for commit table (Output table component??

HCL,

1 9212

Layout - L1*, L1 - What is the difference

3 13577

Un-Answered Questions { Data Warehouse }

What is substr function?

1250

Explain the meaning of Amp?

1247

Explain what are slowly changing dimensions?

1079

What's the difference between timestamp (0) and timestamp (6)?

1260

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1462

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2547

We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

948

What do you mean incremental aggregation?

1131

how to prepare the documentation in business objects and where to get the requirement?

2287

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1122

Explain about core dimension, balanced dimension, and dirty dimension?

1065

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2516

What needs to be done while starting the database?

1165

What Proc glm does?

1148

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9311

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