-
Unconnected Lookup
In which situation do we use unconnected lookup?
Anindya1281
- Jul 4th, 2010
- when we need to call same lookup multiple times in one mapping.For example in a parent child relationship you need to pass multiple child id's to get respective parent id's- when most...
hundwanipankaj
- Apr 6th, 2010
Unconnected Lookup is used when lookup is not used in every reecord. Lookup data is called at the point in mapping that needs it. It can be used in any transformation that support expression. Us...
-
An Agent and A Broker
What is the difference between an agent and a broker?
Inclus12
- Oct 27th, 2009
Yes there is. Let me clarify:-1. An agent represents one Company while a Broker represents the Customer and takes the customer details and goes to multiple companies to get the best quote and...
smsreddy
- May 20th, 2009
Broker is individual and not a part of any organization/company.Agent works for a company for eg : LIC agent works for LIC.
-
Extract / Transform Process
Describe the stages of extract / transform process, including what should happen at each stage and in what order?
6shiva9
- Apr 22nd, 2010
Extract Process: This process extracts data from disparate sources (RDBMS or Flat Files or XML or ERP) to Staging Area. It may be using an ETL tool (ex. Informatica, Datastage, BODI) or simply b...
sagarw9
- Aug 19th, 2009
In the extract process, we extract the data from the different sources like data files, flat files, etc.. into the stagging area or we can say input area for the further processing.Once get files in t...
-
Data Cleansing Phase
What are some typical considerations during the data cleansing phase
SQLGal
- Jun 7th, 2009
The ultimate goal of data cleansing is to improve the organization's confidence in their data. First set the bar for what kind of quality you are trying to obtain. I usually shoot for a 99% level ...
smsreddy
- May 20th, 2009
Before start the cleansing process, do some quality assement for the source data for eg: NULL values for some important columns and -ve or zero values.
-
Data Extraction Tools
What are the different tools available for Data Extraction
cyberdiptikanta
- Jul 26th, 2010
1.Informatica2.Datastage3.Ab-intio4.Oracle Warehouse Builder5.Oracle Data Integrator6.SSIS
smsreddy
- May 20th, 2009
Instead of Extraction we can say Intigration tools ( ETLs) some of those areInformaticaDatastageSASMicrosoft SSISOracle Warehouse Builder
