| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what are the different Reporting and ETL tools available in
the market? | | 2 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 1 |
| what is SMP AND MPP? | | 2 |
| How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example) | | 1 |
| what is the indicator file and where it is used? | | 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 |
| Identifying the bottlenecks in various components of
Informatica and resolving them. | | 1 |
| what are the facilities provided by OLAP to analytical users? | | 1 |
| what are the different forms of normalization? | | 2 |
| 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 |
| 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 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 2 |
| Eliminating of duplicate records without using dynamic lookups | | 2 |
| what happens if the info.server doesn't find the session
parameter in the parameter file? | | 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 |
| without using ETL tool can u prepare a Data warehousing and
maintaining? | | 2 |
| what is the difference between OLTP database and data
warehousing database? | | 2 |
| Difference between flat files and relational sources? | | 1 |
| Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com | NexGen | 157 |
| how do u set the size of block buffer? | | 1 |
| |
| For more ETL Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
