how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer / sajj
If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible
Is This Answer Correct ? | 0 Yes | 0 No |
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.
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
What is data cleaning?
what is granularity in Data ware House?
what are the production issues in datastage?
Eliminating of duplicate records without using dynamic lookups
how many steps are there in etl process?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What is granularity? Please explain with example
What are the new features of informatica 9 version?
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