-
What is the difference between etl tool and olap tools
Amithanbr
- Aug 26th, 2009
ETL TOOL (eg:Informatica, Data stage, Abinitio..)?is for EXTRACTING data from a source systems(a system where client's transactional business information resides) and performing business logic(applyi...
Sujatars
- Jun 16th, 2007
ETL tool is used for Extration ,Transformation(filtering) and loading the data into data warehouse .OLAP tools are used to analitical purpose basically for report generation i.e to retrieve the data from dataware,OLAP is multidimensional model.
-
Cognos vs Informatica
can anybody tell me that what are the processes used by cognos and Informatica for ETL Extraction, Scrubbing and Fusion. If you have any detailed report then please send me onmy mail ID...nm_105@yahoo.co.inthanks in Advance...
raambharathi
- Sep 16th, 2009
Cognos and Informatica are not same tool that does the same work.Informatica is a ETL tool. It extracts data from various sources (Oracle, db2, Sybase, etc) transforms it and loads data into ...
-
User Defined Environment Variables
What is the use of the User defined Environment variables?
veer.dwh
- Sep 20th, 2009
User Defined Environment Variables are used to pass the parameters in job level,stage level and sequncer job level.Regards,Veeru.
-
What is the difference between Power Center & Power Mart?
Answered by kiran on 2005-05-08 09:27:46: Power Mart is designed for: Low range of warehouses only for local repositories mainly desktop environment. Power mart is designed for: High-end warehouses Global as well as local repositories ERP support.
ashrita
- Mar 15th, 2010
Informatica PowerCenter - Has all options, including distributed metadata, ability to organize repositories into a data mart domain and share metadata accross repositories, Partioning is available. In...
lakshmi
- Dec 21st, 2006
Power Center is designed for:High-end WarehousesGlobal as well as local repositoriesPower Mart is designed for:Low-end WarehousesOnly for local repositories
-
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 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
-
Surrogate key
Why we implement sarrogate key in ETL Process?
mallikkd
- Aug 14th, 2010
It is a unique primary key that is not derived from the data that it represents, therefore changes to the data will not change the primary key.In star schema it is used to join Dimension and Fact tables.
ramadevi1111
- Apr 16th, 2009
To generate sequence numberGenerally it starts with 0neBasically it is to differentiate the primary key
-
Explain the ETL process diagram from source to final DWH using multi sources and diagram?
mhollingsworth
- Aug 24th, 2010
[source data (files or whatever)] --> read & parse --> sanitize and format --> [staging area] --> transform --> load --> [data warehouse] --> generate reports
jaggu_mandya
- Jan 18th, 2008
(sources)---------->Staging Area(Transformation)---->Target------>Interface-->ReportsData baseFlat filecobol fileXML file
-
Unconnected lookup
What is the use of unconnected lookup transformation and exaplain with example?
pranambiar
- Oct 26th, 2010
Informatica unconnected lookup can be taken as Oracle function. There are many scenario's in which unconnected lookup is preferred over connected one 1. When same lookup is to be used multiple tim...
-
Delete Child Record transformations
If i delete one record in master table, then the same record is also deleted in dependent table, for this which transformation can we use.
jyothi_rayala
- Feb 28th, 2011
In this case if the sources are relational then in DB while defining foreign key relation itself , if ON Delete Cascade is mentioned then automatically if master records are deleted child records also gets deleted
-
How do you tell aggregator stage that input data is already sorted
jyothi_rayala
- Feb 28th, 2011
2 options to tell aggregator input data is already sorted 1. If the sources are relational ,make sure that number of sorted ports are given in Source qualifier. 2. Include the Sorter transformation be...
Anonymous
- Oct 13th, 2006
By enablign sorted input property in Aggregator Properties
-
What is a staging area? Do we need it? What is the purpose of a staging area?
Answered by Laxmi on 2005-05-13 16:42:53: Staging area is place where you hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging area to hold the data , and perform data cleansing and merging , before loading the data into warehouse.
jryan999
- May 1st, 2008
The staging area is:- One or more database schema(s) or file stores used to “stage” data extracted from the source OLTP systems prior to being published to the “warehouse...
Mamatha
- Oct 24th, 2007
Hi, Staging area is place where you hold temporary tables on data warehouse server.In the absence of a staging area, the data load will have to go from the OLTP system to the OLAP system directl...
-
BO Data Integrator
In BO Data integrator, metadata repository is in
A. Relational DB
B. File System (XML)
C. Proprietary Format -
How do we call shell scripts from informatica?
Answer posted by Staline on 2005-05-27 00:42:44: You can use a Command task to call the shell scripts, in the following ways: 1. Standalone Command task. You can use a Command task anywhere in the workflow or worklet to run shell commands. 2. Pre- and post-session shell command. You can call a Command task as the pre- or post-session shell command for a Session task. For more information...
Hanuma
- Jul 24th, 2011
You can use a Command task to call the shell scripts, in the following ways: 1. Standalone Command task. You can use a Command task anywhere in the workflow or worklet to run shell commands. 2. Pr...
praveenathota
- Nov 13th, 2006
Hi,There are two ways to do this,they are as follows:1)we can use a command task anywhere in the workflow or worklet to run the shell commands.2)In the session task,we can call reusable command ...
-
How to check the existence of a lookup file in a graph ?
How to check the existence of a lookup file in a graph ..The requriement is if Lookup file is present then some search will be carried out in the same else default value will be set. PLEASE NOTE we need to check the existence of the lookup file in graph level only..
-
-
-
Informatica: if flat file name varies day by day ...
If we are using flat file in our loading, and flat file name change daily so how we handle this without changing file name manually daily?
for example: like file name is changing depend on date so what should I do? pls help… -
Clean Data before Loading
Why is it necessary to clean data before loading it into the Warehouse
Prashant Khare
- Oct 3rd, 2012
Data Cleansing is a process of detecting and correcting the corrupt and inaccurate data from table or database.
There are following steps used:-
1) Data auditing
2) Workflow Specification
3) Workflow Execution
4) Post-processing and controlling32kris
- Aug 11th, 2010
Cleaning is required as it helps in maintaining the uniforminty of the target data.
-
If LKP on target table is taken, can we update the rows without update strategy transformation?
Shiv
- Oct 11th, 2012
Hi, If you even do dynamic lookup you should make use of update strategy to mark the records either to insert or update in the target using look-up cache (look-up will be cached on target). your re...
sn3508
- May 12th, 2008
Update strategy transformation determines whether to insert, update, delete or reject a record for the target. We can bypass update strategy transformation by creating a router to divide ro...
ETL Interview Questions
Ans