can be used COM component in Informatica ?
what is granularity in Data ware House?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
What is partitioning? Explain different types of partitioning?
What are the various tools used in etl?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
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.
what are the different Reporting and ETL tools available in the market?
What do you understand by active and passive transformations?
How etl testing is different from database testing?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
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