| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what are the different Reporting and ETL tools available in
the market? | | 2 |
| 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 |
| how do u set the size of block buffer? | | 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 the different forms of normalization? | | 2 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 2 |
| what are the different Reporting and ETL tools available in
the market? | | 1 |
| how do u implement scheduling in Informatica? | | 1 |
| Difference between flat files and relational sources? | | 1 |
| what is SMP AND MPP? | | 3 |
| Eliminating of duplicate records without using dynamic lookups | | 1 |
| Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com | NexGen | 189 |
| Eliminating of duplicate records without using dynamic lookups | | 2 |
| what is the difference between OLTP database and data
warehousing database? | | 2 |
| what is the meant by Normalization and de-normalization? | | 1 |
| what are Lookup caches options? Including persistent caches. | | 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 | | 2 |
| 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 |
| what is the difference between OLTP database and data
warehousing database? | | 1 |
| what is the difference between shortcut of an object and
copy of an object? compare them? | | 1 |
| |
| For more ETL Interview Questions Click Here |
Site Map
