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 shift table? have you ever created shift that?

Accenture, Clinical Research, Quintiles,

2 27778

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

CTS,

6 9329

can i call router is a passive transformation

2 6203

what is the difference between filter and router transmissions

2 6779

how can i provide security to my reports in report studio?

TCS,

3 7363

what is work of PUSH DOWN option

Wipro,

2 7532

who to split dimentions into sub dimention

Wipro,

3 7646

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 4445

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

Wipro,

10 17026

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 10538

It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

2565

what is reprompt?

TCS,

3 19330

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

CTS, IBM,

3 22268

what is DSS?

3 6474

hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...

2 4806

Un-Answered Questions { Data Warehouse }

How would you format some text using css to be verdana and bold?

1143

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2432

What is dimensional table?

1159

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

2309

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

2167

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

2090

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

1174

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2146

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

2306

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

1118

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?

1099

What sort of existing documents should business analysts refer to when starting on a new project?

1078

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

2261

Write the unconnected lookup syntax?

1145

EXL informatica Questions

1458

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