| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Eliminating of duplicate records without using dynamic lookups | | 1 |
| how do u automate Extraction process? | | 1 |
| what is the difference between OLTP database and data
warehousing database? | | 2 |
| what are the facilities provided by OLAP to analytical users? | | 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 |
| how do u implement scheduling in Informatica? | | 1 |
| what is the difference between normal & bulk loading? and
which one is recommended ? why? | | 1 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 2 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 1 |
| if u can't find what you are looking for in lookup table,
how do you handle? | | 1 |
| Eliminating of duplicate records without using dynamic lookups | | 2 |
| CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM" | | 8 |
| 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 |
| 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 |
| what are Lookup caches options? Including persistent caches. | | 1 |
| what are the different Reporting and ETL tools available in
the market? | | 1 |
| what are the different Reporting and ETL tools available in
the market? | | 2 |
| what is the indicator file and where it is used? | | 1 |
| what is meant by drill through?(Mascot) | | 1 |
| Identifying the bottlenecks in various components of
Informatica and resolving them. | | 1 |
| |
| For more ETL Interview Questions Click Here |