| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what are the different Reporting and ETL tools available in
the market? | | 1 |
| how do u implement scheduling in Informatica? | | 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 |
| Eliminating of duplicate records without using dynamic lookups | | 2 |
| what are the different forms of normalization? | | 2 |
| what happens if the info.server doesn't find the session
parameter in the parameter file? | | 1 |
| what is the difference between OLTP database and data
warehousing database? | | 2 |
| what is SMP AND MPP? | | 2 |
| what is meant by drill through?(Mascot) | | 1 |
| can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine. | | 1 |
| 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 can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example) | | 1 |
| Difference between flat files and relational sources? | | 1 |
| what are the facilities provided by OLAP to analytical users? | | 1 |
| what is the difference between OLTP database and data
warehousing database? | | 1 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 2 |
| Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com | NexGen | 158 |
| Hello all,
Source Table(Flat File):- Target Table(Flat File):-
Date Date
01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008
My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?
Thanks
| | 3 |
| 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 |
| can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine. | | 1 |
| |
| For more ETL Interview Questions Click Here |