| Other ETL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| what are the facilities provided by OLAP to analytical users? |
| 1 |
| list the transformation used for the following:Heterogeneous
sources,Homogeneous sources,Find the 5 highest paid
employees with in a dept,create a summery table,generate
surrogate keys |
| 2 |
| we hava more than 1000 records. i have to select first 5
record, last 5 record and 5 records from middle of the source.
how can i do in oracle as well as in informetica?? |
| 4 |
| What is factless fact schema? |
| 3 |
| working of line item dimension......pls,tell overall flow
|
| 1 |
| when should one create lookup transformation ? |
| 2 |
| WHY CANT WE SEE THE DATA IN DATASET |
IBM | 1 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. |
| 5 |
| how do u set the size of block buffer? |
| 1 |
| what are Lookup caches options? Including persistent caches. |
| 1 |
| 1. if lookup tr is giving poor performamence. what u do.
2. i have emp,dept table. i want output
ename,empno,dname,max(sal).
3. can any one tell me project flow in real time scenario.
please send me mail any queries and answers
my mail id is yaparala@gmail.com |
iGate | 2 |
| what is the difference between OLTP database and data
warehousing database? |
| 3 |
| |
| For more ETL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
