1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Explain briefly scd type2 in datastage7.5x2(parallel)

IBM,

1 5281

Order of Evaluation of Parameters

 2 11912

How to convert RGB Value to Hexadecimal values in datastage?

 3448

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

Satyam,

3 7826

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

iGate,

7 8890

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

 1 8167

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

 1 4786

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

US Technology,

6 7880

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

IBM,

2 5599

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

IBM,

3 5907

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

 4 6440

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

 2 5112

/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

 5 5896

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

CTS, TCS,

1 5777

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)

 1660

Un-Answered Questions { Data Warehouse }

What is difference between custom hierarchy and report based hierarchy?

543

If a variable contains letters or special characters, can it be numeric data type?

753

What are data validation strategies for data mart validation after loading process?

526

What is spool space? Why do you get spool space errors?

501

What is inner join and outer join?

606




What information does a .dbc file extension provides to connect to the database?

707

What are all the different types of prompt in cognos?

538

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1413

Can you define transformer?

514

Explain the different types of data warehousing?

559

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2833

What is data warehouse architecture?

568

Explain what task is 98% of the required work of a business analyst?

593

Explain the main difference between inmon and kimball philosophies of data warehousing?

546

flat filevalidation in informatica

1737

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