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

what is runtime variable?

TCS,

3 7422

which is better perfomancewise lookup or joiner and why?can anyone give example?

TCS,

6 12105

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

TCS,

2872

how to configure databases through datastage

2 12363

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 9690

How to delete first 3 rows & last 3 rows in target table in informatica

TetraSoft,

6 14823

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9764

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

IBM,

2 7064

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

Cognizant, Flextronics,

3 7885

what is the size ur source like(file system or database)? how many record daily come u r banking project?

Cognizant, Flextronics,

2155

what are the challenge face in u r project?explain me

iGate, TCS,

1 3541

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

iGate,

3 6876

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 7578

How can you achieve scan using reformat ?

2 13225

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 5097

Un-Answered Questions { Data Warehouse }

Define oconv () and iconv () functions in datastage?

1423

Explain the parallel data extension in teradata?

1109

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1354

Explain fact degradation?

1001

describe how to adjust the performance of data integrator? : Sas-di

1019

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2133

Name validation tools used in SAS

1190

what is ae onset date n what is RDS

2591

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1397

what the mean of version error in crystal?

2405

how can we create rank using datastage?what is the meaning of rank?

8802

what is snowflake schema? : Sas-di

1224

How many types of nodes supported by Redshift and what are the functions of nodes?

What is SAS informats?

1114

What Is Snow Flake Schema?

1218

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