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 incompactabulity error in sap bo

2 7061

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

Cap Gemini,

5 13293

Difference b/n proc means and proc summary procedures?

Accenture,

3 9718

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

Cap Gemini,

5 11978

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 6279

There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)

CTS, IBM,

1 7496

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

Cognizant, UHG,

3 16638

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

TCS,

1 6894

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

CTS,

11 18817

Difference between the Sequence and Sequencer in DS?

TCS,

1 11932

Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 4148

can we have to do changes in session property when we are dynamically generating target files?

Wipro,

3 9039

Types of error logs in Informatica?

2 12071

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

Amdocs,

4 8448

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

IBM,

1 5918

Un-Answered Questions { Data Warehouse }

what is the difference between filter and condition?

1076

Explain incremental aggregation in informatica

1144

What are the types of hierarchies?

1039

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1085

What are the three tiers in etl?

1125

How one source columns or rows to be loaded in to two different tables?

1144

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4207

What a datastage macro?

1074

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1150

In sas, what are the areas that you are most interested in? : sas-grid-administration

1092

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

1008

What is main difference mapplets and mapping?

1208

What is data partitioning?

1224

Syntax for case when statement?

1077

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2568

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