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

HOW TO YOU LOAD TIME DIMENSION

1 5489

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1 2090

define galaxy repository in informatica

1 2302

what is object level locking ? where do appear this type of locking ?

1 3557

when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.

1 6129

in sap bi we have wad, then why we go for sap bo

1 3447

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

IBM,

5 9937

have you developed documents in your project? and what documents we develop in realtime?

IBM,

2 6733

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

IBM,

3 8614

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

Syntel,

5 11703

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

TCS,

1 6411

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

TCS,

1 3532

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

ITC Infotech, TCS,

5 11073

Can i apply drill through on chart in report studio?

TCS,

4 10831

Can i apply drill through on master detail relationship report?

TCS,

2 8393

Un-Answered Questions { Data Warehouse }

What is node? How many nodes and amps used in your previous project?

1167

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2081

Have you have ever worked in unix environment and why it is useful in datastage?

1210

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1095

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2163

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274

What is the difference between business requirement document and use case document.

1073

draw informatica architecture 8.6 ?

3939

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2089

what is document design in boxi,have u participate in that

2290

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2169

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2480

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 ?

2540

Explain about a time when you discovered a more efficient way to do a work task?

1214

explain in detail about type 3?

1078

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