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

Can we update the data in flat file using update strategy?

3 16922

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

HCL,

1 2441

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

TCS,

2 6859

how many rows sorted in sort stage by default in server jobs

Syntel,

1 4066

what is the difference between aggregation and role up aggregation ?

Systime,

1 5233

Compare and contrast aggregates & indexes

IBM, TCS,

1 3844

Compare aggregates and data marts

TCS,

1 2839

what role views play in dimensional modeling?

TCS, Zensar,

1 6016

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

IBM,

1 5236

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 8437

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

CTS,

7 24984

how to define satge variables in transformer stage

2 22871

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

TCS,

3 10743

How to display errors in datastage?

TCS,

1 4141

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

1 17899

Un-Answered Questions { Data Warehouse }

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

Demonstrate experience in maintaining quality process standards?

2675

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1244

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 pls pls pls muthireddi@gmail.com

2213

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

4265

Hi, If anyone has base SAS certification dumps, please share.

1940

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2549

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2795

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1964

What is aggregate table and aggregate fact table ... Any examples of both?

1119

EXL informatica Questions

1462

What is dimensional table? Explain the different dimensions.

1270

how to generate the test data in sas without input data? : Sas-administrator

1207

Write the unconnected lookup syntax and how to return more than one column.

1174

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1771

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