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 anybody tell me when do use 'running total'...give an example for the usage of running total

2 9638

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

HCL,

2809

where do we see the run time of the report ?

2 5959

I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?

4 8173

How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?

5 8394

can we create aliases for every table beforehand? if yes whar are the disadvantages?

AG Technologies,

5 10956

what are the disadvantages of alias?

Patni,

6 20440

WHAT IS ROW LEVEL SECURITY IN BO?

Wipro,

7 24782

What is security level in BO ?

Accenture,

3 10502

Can we create a web page where the report directory and the output can be viewed directly across cognos connection?

TCS,

2 7010

Which service handles requests for cognos connection,query studio and event studio.

TCS,

2 11097

plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?

2 5859

how to do Ad-hoc reporting ?

IBM,

6 13273

i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?

2 6909

Is cognos models are version compatible?

2 5146

Un-Answered Questions { Data Warehouse }

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1041

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

2491

How do you remove duplicate records in informatica? And how many ways are there to do it?

1231

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1994

what are the data modeling tools you have used?(polaris)

2057

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

1079

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2310

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

4259

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2261

faq's on cognos

4112

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

1173

explain in detail about type 3?

1082

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2298

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

2167

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