| Other ETL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example) | | 1 |
| what is meant by drill through?(Mascot) | | 1 |
| if u can't find what you are looking for in lookup table,
how do you handle? | | 1 |
| what happens if the info.server doesn't find the session
parameter in the parameter file? | | 2 |
| without using ETL tool can u prepare a Data warehousing and
maintaining? | | 2 |
| what is the difference between OLTP database and data
warehousing database? | | 1 |
| 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 |
| how do u implement scheduling in Informatica? | | 1 |
| what are variable ports and list two situations when they
can be used? | Satyam | 3 |
| what are the different Reporting and ETL tools available in
the market? | | 1 |
| how do u automate Extraction process? | | 1 |
| what are Lookup caches options? Including persistent caches. | | 1 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 1 |
| Eliminating of duplicate records without using dynamic lookups | | 1 |
| what is the meant by Normalization and de-normalization? | | 1 |
| Eliminating of duplicate records without using dynamic lookups | IBM | 3 |
| how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa. | | 2 |
| how do u implement unconn.stored proc. in a mapping? | | 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 |
| what is the indicator file and where it is used? | | 1 |
| |
| 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
