-
Loading data from Datamarts
Which approach is better and why?Loading data from datamarts to datawarehouse or vice versa?
Mehul@DWH
- Oct 9th, 2008
1. The direction of the data load depends on the approach that was adopted while designing the Warehouse and the datamart. If the top down approach, which Kimbal mentions is used, then data will ...
-
Source Qualifier in Informatica
What is the Technical reason for having Source Qualifier in Informatica? Can a mapping be implemented without it? (Please don't mention the functionality of SQ) but the main reason why a mapping can't do without it...
manojrana
- Apr 7th, 2010
The most important significance of source qualifier is that it converts the datatypes (coming from a source) into informatica compatible datatypes.Rest all properties like distinct, overide, filtering records can be achieved by other transformations of informatica as well.
chandra Bose
- Sep 4th, 2007
In informatica source qualifier acts as a staging area, and it will create its own data types which are related to source data types
