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 17180

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 ?

2116

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

Accenture, Icon,

2364

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

Rolta,

1 3385

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

3 7246

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

Flextronics,

5 11534

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

TCS,

2 8405

How mapping parameter and variable works

1 4345

How to connect mainframe to Abinitio?

CTS,

1 7376

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

1 8160

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

2284

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

CTS,

1 9039

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

CTS,

2882

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

1 7716

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

2156

Un-Answered Questions { Data Warehouse }

What is maximum number of rows and cols can be handled in SAS?

1678

how to add a new records into source?

2061

what is the difference between list and crosstab?

In SAS explain which statement does not perform automatic conversions in comparisons?

1376

can metadata be manually edited? If yes, how?

1073

How can we improve the performance in datastage?

1150

Can you define drill down and drill up?

1085

Explain how abinitio eme is segregated?

1568

Is it possible to create multiple domains on a single Informatica server?

1291

Explain difference between onrow and onread method?

941

What are the 3 components in sas programming?

1247

Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

2376

what is the use of structures?how many nodes can u create in a structure?

2295

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4427

-----------Diff b/w OLAP and RDBMS?

2109

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