| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how do u implement unconn.stored proc. in a mapping? | | 1 |
| what is SMP AND MPP? | | 2 |
| Identifying the bottlenecks in various components of
Informatica and resolving them. | | 1 |
| what is meant by drill through?(Mascot) | | 1 |
| 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 |
| without using ETL tool can u prepare a Data warehousing and
maintaining? | | 2 |
| 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 | IBM | 3 |
| 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 |
| Eliminating of duplicate records without using dynamic lookups | | 1 |
| how do u set the size of block buffer? | | 1 |
| Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com | NexGen | 158 |
| 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 |
| 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 is the difference between normal & bulk loading? and
which one is recommended ? why? | | 1 |
| what is the difference between OLTP database and data
warehousing database? | | 2 |
| what are variable ports and list two situations when they
can be used? | Satyam | 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 |
| 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 |
| |
| For more ETL Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
