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

Difference between Qualify and group

4 17056

i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

2069

what type of graphs we will create(for 2+years candidates)?

Accenture, Icon,

2316

How to get red line in the graph at some point (value)? Example : In graph at 200000 value

Rolta,

1 3325

Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 7131

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

Flextronics,

5 11361

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

TCS,

2 8306

How mapping parameter and variable works

1 4264

How to connect mainframe to Abinitio?

CTS,

1 7300

Difference between public and private projects and how to make private to public?

1 8063

what is the difference between i)public ii)private iii)common and client projects?

2246

How to migrate the code FROM development to QA and QA to production?

CTS,

1 8963

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

CTS,

2843

Difference between private project parameters ,public project parameters and common project parameters?

1 7641

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

2120

Un-Answered Questions { Data Warehouse }

What does microstrategy intelligence server allow users to do?

999

what is the use of catlog or catlogfile?

2386

How is character variable converted into numeric variable and vice versa?

1185

What is the information present in the cognos configuration file?

971

What are various warehousing tools?

1023

what is pmrep command?

2446

What is a data warehousing?

1168

Is it possible to join multiple Databases in a Catalog?

1134

What are the difference between sas functions and procedures?

1164

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2052

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2141

explain the proc in sas? : Sas-administrator

1100

Explain the special input delimiters used in sas programming.

1017

What are the types of hierarchies?

1033

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1138

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