| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com | NexGen | 158 |
| In the SEQ generator which property has to be set to
generate seq No. when the input data is more than the max
limit. | Accenture | 3 |
| 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 |
| Which type or t/s is used to convert rows into column &
column into rows | Infosys | 6 |
| can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine. | | 1 |
| Eliminating of duplicate records without using dynamic lookups | | 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 |
| what are the facilities provided by OLAP to analytical users? | | 1 |
| how do u implement scheduling in Informatica? | | 1 |
| what happens if the info.server doesn't find the session
parameter in the parameter file? | | 2 |
| what is the meant by Normalization and de-normalization? | | 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 |
| Eliminating of duplicate records without using dynamic lookups | IBM | 3 |
| what is the difference between OLTP database and data
warehousing database? | | 2 |
| what is the indicator file and where it is used? | | 1 |
| what are the different forms of normalization? | | 2 |
| what are Lookup caches options? Including persistent caches. | | 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 |
| 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 |
| |
| 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
