| Other ETL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| how do u set the size of block buffer? |
| 1 |
| we hava a flat file having more than 1000 records and two
targets. i have to write first half of the rows into first
targets and next half of rows into second target. how can i
do in informetica?? |
| 1 |
| Identifying the bottlenecks in various components of
Informatica and resolving them. |
| 2 |
| what is the meant by Normalization and de-normalization? |
| 2 |
| what is the indicator file and where it is used? |
| 1 |
| I have a Flat file with more no. of Records also including
duplicate values. But i need distinct values to one target and
remaining records to another target in Informatica way |
| 2 |
| what are the different forms of normalization? |
| 2 |
| Eliminating of duplicate records without using dynamic lookups |
| 1 |
| what is HISTOGRAM? how to generate statistics? |
| 1 |
| what is session partitioning? |
| 1 |
| what are the facilities provided by OLAP to analytical users? |
| 1 |
| If you concatenate data from a normalizer
transformation,the ports you concatenate cannot include
OCCURS(T/F). |
| 1 |
| |
| For more ETL Interview Questions Click Here |