| Other ETL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| what are Lookup caches options? Including persistent caches. |
| 1 |
| working of line item dimension......pls,tell overall flow
|
| 1 |
| what are Lookup caches options? Including persistent caches. |
| 1 |
| When you have 2 servers in two different time zone and if
you need to extract data from 1 server and load it in
another server, how do you go about it? Best method to be
used. |
| 3 |
| 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 |
| can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine. |
| 2 |
| Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose? |
| 1 |
| what are the different Reporting and ETL tools available in
the market? |
| 3 |
| What is factless fact schema? |
| 3 |
| if u can't find what you are looking for in lookup table,
how do you handle? |
| 1 |
| what are the different Reporting and ETL tools available in
the market? |
| 1 |
| what is session partitioning? |
| 1 |
| |
| For more ETL Interview Questions Click Here |
Site Map
