Can any one let me know where can i find the list of ETL & reporting tolls available in the market. thanks in advance

Prakirn

• Dec 19th, 2020

From performance perspective - Ab Initio
From license cost and market cap perspective - Informatica

shobha

• Mar 20th, 2019

ETL tools are: Informatic power center, Abinition, Data stage, SSIS, ODI

Answer Question  Select Best Answer

Raja

• Jun 12th, 2019

if you have Unix, please use this to command on source and target. (checksum bytecount filename). in the file name pls provide your source file name and once the target is also loded, please provide ...

Ayaskanta Ratha

 Profile Answers by Ayaskanta Ratha Questions by Ayaskanta Ratha

• Nov 17th, 2015

You can union both the minus and then look for the result

Answer Question  Select Best Answer

In ETL testing if the src is flat file, then how will you verify the data count validation?

Divya Jain

• May 16th, 2017

Say file Name: abc.txt and delimited with a comma(,)

answer:
hear -1 abc.txt | awk -F "," {print $NF}

Shivnath Rojatkar

• May 12th, 2017

Using wc command in UNIX, you can check the count of records.

Answer Question  Select Best Answer

Answered by kiran on 2005-05-08 09:32:14: An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and passes through the same number of rows that was given to it as input.

vipul kr

• Nov 29th, 2015

Hello Guys,

Do remember those transformations that change the order of records passing through it are also active transformation. like sorter without checking distinct option also said to be active.

JIYAJI

• Jan 14th, 2015

ACTIVE TRANSFORMATION:- If the no. of records from the source is not equal to the no. of records in the targets then those transformation is known as ACTIVE TRANSFORMATION. . . PASSIVE TRANSFORMATIO...

Answer Question  Select Best Answer

Siddartha

• Mar 23rd, 2015

9.6.,1

Mark Rutherford

• Jun 18th, 2013

9.5.1

Answer Question  Select Best Answer

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

 Profile Answers by jryan999 Questions by 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...

Answer Question  Select Best Answer

Say in a source there are 1 lakh records and in Target there are 1 lakh records. Some records in a column having the mismatch value (.ie., Instead of displaying 1000 in a column, it is displaying as 100 in Target column) The source file is from an DB2 and, Oracle (different source) and, Target is an SQL server. So how to find it by a simple way?

santhosh gujja

• Oct 15th, 2015

1) Select * from source -- Convert this output to a Excel Sheet
2) Create an empty table with the same table structure as of source and Load the excel sheet into that table in SQL Server.
Then compare the results by using minus query between source and target within SQL Server.

mukesh

• Sep 28th, 2015

Considering the source as correct data. Use source data as an external file in oracle and use a MERGE command to Update the date ( Correct the data in the target) or Insert if the entire record is missing. MERGE with External table will be very fast as oracle take care of the parallel load.

Answer Question  Select Best Answer

sravanthi K

• Aug 7th, 2018

Hi Anand ,
I am exactly looking for this info. could you please elaborate on this design implementation in datastage in all the three methods of delta load you mentiond.

Thansks,
Savanthi

Anand Yadav

• Sep 2nd, 2016

There are three way to do increment load in ETL as per my knowledge:
1: Delta loading using parameter file.
2: Delta loading using control table.
3: Delta loading using max variable where max variable is last updated date.

Answer Question  Select Best Answer

Rajesh

• Aug 22nd, 2022

ODS is mainly used to integrate the data of different Sources having same functionality of the data into one integrated model. This model is mostly denormalized and will not be useful for reporting. E...

Ankush

• May 18th, 2017

You mentioned ODS comes after staging area is not true i guess. Flow is like ODS->staging->DWH as per my knowledge. Kindly correct me if wrong.

Answer Question  Select Best Answer

SHIV

• Dec 28th, 2011

The main difference between connected and unconnected lookup is, we can call unconnected lookup based on some conditions but not the connected lookup.

Sreedhar Lokaray

• Nov 2nd, 2011

Lookup can be used as Connected or Unconnected. Apart from cache and receiving input values from pipe line, there is one more difference. If you want to use the same lookup more than one in a mapping ...

Answer Question  Select Best Answer

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

 Profile Answers by ashrita Questions by 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

Answer Question  Select Best Answer

Amithanbr

 Profile Answers by Amithanbr Questions by 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

 Profile Answers by Sujatars Questions by 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.

Answer Question  Select Best Answer

snareshinfo

 Profile Answers by snareshinfo Questions by snareshinfo

• Nov 24th, 2008

Aggregator Transformation  Expression Transformation  Filter Transformation  Joiner Transformation  Lookup Transformation  Normalizer Transformation  Rank Transformation ...

naveen

• Feb 16th, 2007

Can u plz send the detailed description of each transformationthanx

Answer Question  Select Best Answer

Sriram

• Sep 7th, 2015

Mapplet which we can use more than one transformation logic that is Expression and Joiner Transformation both can used in Single in the Mapplet.

kotesh chowdary

• Aug 26th, 2011

SIMPLY to say::::::::::::::::::

worklet : set of sessions

mapplet : set of transformations that can be called within a mapping

Answer Question  Select Best Answer

Why we implement sarrogate key in ETL Process?

mallikkd

 Profile Answers by mallikkd Questions by 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

 Profile Answers by ramadevi1111 Questions by ramadevi1111

• Apr 16th, 2009

To generate sequence numberGenerally it starts with 0neBasically it is to differentiate the primary key

Answer Question  Select Best Answer

Kalpana gopinath

 Profile Answers by Kalpana gopinath Questions by Kalpana gopinath

• Apr 3rd, 2008

ODS is nothing but operational data source. It contains  most recent data .it contains around 30-60 days data  It is placed in between source system and staging area..   reports can also be taken in ODS .

saurabh verma

• Mar 8th, 2007

Operational Data Store (ODS): An ODS is an integrated database of operational data. Its sources include legacy systems and it contains current or near term data. An ODS may contain 30 to 60 days of information, while a data warehouse typically contains years of data. it is before staging

Answer Question  Select Best Answer

Describe the stages of extract / transform process, including what should happen at each stage and in what order?

6shiva9

 Profile Answers by 6shiva9 Questions by 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

 Profile Answers by sagarw9 Questions by 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...

Answer Question  Select Best Answer

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…

Charu

• Jan 24th, 2012

Use the indirect filelist option at informatica session. say the filelist name is daily_file.txt put a shell script daily_filename.sh at the pre-session command. The content of daily_filename.sh is ...

SHIV

• Dec 28th, 2011

You can use Informatica File List option in target to get the dynamic file names along with the transaction control transformation so that you can create dynamic filenames based on some transaction properties.....

Answer Question  Select Best Answer

This is my single column table
====================

===
|10|
===
|20|
===
|30|
===
|40|
===
and I want to print out put like this

O/p:
10
===
30
===
50
===
70
How can i get this ?

Rajath

• Dec 15th, 2017

Use CSUM command

Akash

• Jun 24th, 2017

Use router {mod(IP,2)=1}

Answer Question  Select Best Answer

Answered by kiran on 2005-05-08 09:20:30: Informatica Metadata contains all the information about the source tables, target tables, the transformations, so that it will be useful and easy to perform transformations during the ETL process.  The Informatica Metadata is stored in Informatica.

VIJAYdw9

 Profile Answers by VIJAYdw9 Questions by VIJAYdw9

• Nov 14th, 2008

Metadata is simply documentation for a digital geospatial dataset. It is a text document that describes the who, what, when, where, why and how questions about the data, so that a potential data user can decide whether or not the data is appropriate for his/her use."

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Dec 6th, 2007

All informations about the mappings,workflows such as Source,target,transformations are converted into metadata format and it is stored in the Repository database.The repository database is a open database,which can be accessible by the Repositoy server and Informatica server.Cheers,Thana

Answer Question  Select Best Answer