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 traffic lighting in business objects?

1 6785

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

ABC, TCS,

3806

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest

3 9070

What is sdlc in bo?

2 4324

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

HCL,

1 4352

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

NTT Data,

3 7257

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

NTT Data,

2 7774

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

Cognizant, HCL,

1 9226

what is the difference between java script and html in cognos?

IBM,

1 5688

what is diff b/w datastage 8.1,8.5,8.7?

IBM,

1 9662

how does work server jobs?

1 4468

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

Polaris, Zensar,

5 10338

How we can see table structure?

iGate,

2 6774

What exact we can see in table?

1 3958

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2915

Un-Answered Questions { Data Warehouse }

define the logic behind the sparsity in cubes?

Differentiate between source qualifier and filter transformation?

1588

What sort of existing documents should business analysts refer to when starting on a new project?

1016

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2378

What is the difference between STOP and ABORT options in Workflow Monitor?

1275

Explain dimension table ?

989

How to limit the max no of rows retrieved in the report?

995

What is metadata in context of a datawarehouse?

1072

What are differences between teradata and ansi session modes in teradata?

1183

How to load last n records of file into target table - informatica

1091

Can you define a catalog and types of catalogs in cognos?

1067

Explain the characteristics of cognos?

1053

Where the applications and where ware house management system is used?

1025

What is level prompt?

970

what are the dimensions that you have in your current project?list them?

2037

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