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

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 8040

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

IBM,

1 2207

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

IBM,

1 4385

Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 5633

what is mean by complex business rule ?

Cap Gemini,

1 2235

Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q

45 52675

hi my name is siraj i want to know cognos queriy language

1 2340

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

Wipro,

1 3785

why union is active transformation?

IBM,

4 8420

how to use incremental load?

TCS,

2 8230

My source table having some records ,i want load 1st record and last record into one target?

iGate,

3 9995

what is incremental aggregation ,with example?

2 9359

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

DELL,

8 13754

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1 2146

How many ways we test the universe & Report?

2 6253

Un-Answered Questions { Data Warehouse }

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

1998

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

1178

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.

2816

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

2060

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2175

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

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

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

1086

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

2095

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2107

what are the names of the reports that you prepared?

1198

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2771

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

1940

what are the dimensions that you have in your current project?list them?

2095

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