How can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause whenever u select the source data in informatica it shows it can take only character data
Latest Answer : Cache are stored in Repository. ...
If you source data from a system that you (warehouse team) have no authority to enforce data quality at the source level, how do you handle this? Do you apply data validation just after you stage the data? Or do you enforce it at the “end” of the flow (typically as you’re pushing it into the data mart)? Or do you not enforce validation at all?
Centralized metadata architecture gives primary advantage forSource data analysisTarget data analysisCounterpart metadata buildEnd to end impact analysis
A common capacity problem with Data Warehousing involvesData extract transfer of bulk filesNetwork overloadInadequate BRAPComplex data structure
The DW process model is the result of designing refresh processing and consists of specifications for all the following EXCEPTMapping of source data to target dataMeasuring to meet monitoring requirementsInformation deliveryInterpreting and encrypting of metadata
How do you handle the changing no of files as source in the mapping/session which loads the data in a Relational table
