| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is meant by drill through?(Mascot) | | 1 |
| we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record | | 1 |
| Eliminating of duplicate records without using dynamic lookups | IBM | 3 |
| what is the difference between OLTP database and data
warehousing database? | | 1 |
| how do u automate Extraction process? | | 1 |
| what are the facilities provided by OLAP to analytical users? | | 1 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 2 |
| what is the indicator file and where it is used? | | 1 |
| what is a parameter when and where do u them when does the
value will be created. Designing time, run time. If u don't
create parameter what will happen? | | 1 |
| Identifying the bottlenecks in various components of
Informatica and resolving them. | | 1 |
| when should one create lookup transformation ? | | 1 |
| what is the difference between OLTP database and data
warehousing database? | | 2 |
| what is the meant by Normalization and de-normalization? | | 1 |
| if u can't find what you are looking for in lookup table,
how do you handle? | | 1 |
| what is HISTOGRAM? how to generate statistics? | | 1 |
| how do u implement unconn.stored proc. in a mapping? | | 1 |
| you have created a lookup transformation for a certain
condition which if true returns multiple rows. when you go
to the target and see only one row has come and not all. why
is it so and how it can be corrected. | | 3 |
| can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine. | | 1 |
| what are the different Reporting and ETL tools available in
the market? | | 1 |
| Difference between flat files and relational sources? | | 1 |
| |
| 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
