| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 | | 1 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 2 |
| when should one create lookup transformation ? | | 1 |
| what is the indicator file and where it is used? | | 1 |
| what is meant by drill through?(Mascot) | | 1 |
| what are variable ports and list two situations when they
can be used? | Satyam | 3 |
| 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 |
| Eliminating of duplicate records without using dynamic lookups | IBM | 3 |
| what is the difference between OLTP database and data
warehousing database? | | 2 |
| what happens if the info.server doesn't find the session
parameter in the parameter file? | | 2 |
| 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 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 1 |
| 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 are the facilities provided by OLAP to analytical users? | | 1 |
| how do u automate Extraction process? | | 1 |
| How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example) | | 1 |
| Identifying the bottlenecks in various components of
Informatica and resolving them. | | 1 |
| how do u set the size of block buffer? | | 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 |
| |
| For more ETL Interview Questions Click Here |
Site Map
