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

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

Accenture,

1 5107

When we deploy the report to live the client get the data error how can we resolve that

CTS,

1 6372

how to improve the report performance?

1 6245

What is galaxy shema

CGI,

2 7194

To what type of programms have you used scratch macros?

Novartis,

1 2618

which one is better either active or passive transformation in informatica

1 4933

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

IBM,

6 12687

Hi Friends, My name is Priya,am new to this Forum. am looking for SAS Platform Administration Interview Questions.I searched every where but I couldn't find any where.please can anyone help me with the FAQ's. It would be a great favor to me if you can email the Interview Questions to priyafeb84@gmail.com

2101

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

2138

Hi,please suggest me how to creat username while creating a report.

IBM,

1 7794

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

IBM,

1 2453

1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?

iGate,

1 5472

Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com

3399

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

1993

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 3339

Un-Answered Questions { Data Warehouse }

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

1224

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

1932

Hi friends, what are the new features in abinito3.0?

2853

How to add default rules in transformer?

1277

draw informatica architecture 8.6 ?

3939

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324

EXL informatica Questions

1451

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2253

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1189

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

1164

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

1113

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2338

2138

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