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 can u convert this 25-jul-2010 from numeric to charcter?

3 7812

how to through logic of informatica using the push down optimization into oracle.

Hexaware,

2 7970

Is there any model difference between ODS and DWH

Zensar,

2 7519

How You Pull the records on daily basis into your ETL Server.

TCS,

2 7341

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

Mphasis,

2 15242

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

Zensar,

2 6922

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

Zensar,

1 7276

How you count the number of records available at your source?

Zensar,

3 14563

How you load distinct records into one target and duplicate records into another target?

Mphasis,

3 16860

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

HP,

5 11660

write a query to get maximum salary from the employers table without duplicates....kindly help me

CTS,

5 10313

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

TCS,

3 7422

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

HP,

3 9264

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

Qwest,

1 5964

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

CTS,

2 14134

Un-Answered Questions { Data Warehouse }

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2796

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

1176

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2828

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

2860

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1771

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

2095

EXL informatica Questions

1463

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

848

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

1150

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4797

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

2108

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

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

2313

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2215

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

2268

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