Data Warehouse Interview Questions
Questions Answers Views Company eMail

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

IBM,

1 5257

Order of Evaluation of Parameters

2 11843

How to convert RGB Value to Hexadecimal values in datastage?

3426

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 7786

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 8821

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 8140

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

1 4762

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

US Technology,

6 7828

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

IBM,

2 5571

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 5878

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

4 6387

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 5087

/* 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 5855

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

CTS, TCS,

1 5751

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)

1646


Un-Answered Questions { Data Warehouse }

What are the various types of transformation?

615


Explain the key challenges that you face while performing etl testing.

548


Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

501


Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

1554


What is the advantage of using shortcuts?

620






How abinitio eme is segregated?

764


What are all types of Batches?

549


What is data analysis?

522


How to create an external dataset with sas code?

562


How does the aggregator transformation handle null values?

680


Explain the meaning of Amp?

561


what is treatment emergent events and treatment emregent adverse event

1920


Code the tables statement for a single-level (most common) frequency?

442


How many dimensions are there in informatica?

597


Explain the data types present in bo n wht happens if we implement view in the designer n report?

519