Ram

• Feb 28th, 2006

  Hi,   When u load data intitially in to datawarehouse it will be Full Load.   If u r loading data everyday in to datawarehouse it will be incremental load   Thanks,   Ram 

Sriharsha Hanumanth

• Aug 23rd, 2005

Full Load: completely erasing the contents of one or more tables and reloading with fresh data.  Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.

Answer Question  Select Best Answer

jryan999

 Profile Answers by jryan999 Questions by jryan999

• May 1st, 2008

In a warehouse I would recommend analyzing the data either after each load has completed, or periodically (week-end or month-end) depending upon the data volumes and therefore the effort required. You...

ramana_pasula

 Profile Answers by ramana_pasula Questions by ramana_pasula

• Sep 11th, 2007

Analyze your_table_name compute statistics;

Answer Question  Select Best Answer

sri_test

 Profile Answers by sri_test Questions by sri_test

• Dec 16th, 2008

Like ETL SPEC,they create a document containing the source table (Schema name) and a target table (another schema name) with the logic used in transforming source to target. We have to write database ...

balaji.m

• Nov 26th, 2007

Hi,     Yes, We Can Test By Using Debugger before u run the session in Informatica

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Informatica Metadata Exchange (MX) provides a set of relational views that allow easy SQL access to the Informatica metadata repository. The Repository Manager generates these views when you create or...

dhpuneet

 Profile Answers by dhpuneet Questions by dhpuneet

• Jan 18th, 2006

Hi Ravi ,If possible please elaborate on Informatica SuperGlue.RegardsPunu

Answer Question  Select Best Answer

PFD333

• Nov 6th, 2006

Unconected lookups are used in cases where it is not necessary for all the rows to pass through it i.e. for each i/p row query need not be done.

venkata veluguri

• Oct 15th, 2006

We can use more than one return port using Un-connected Lookup (Lookup override).  As per my knowledger Un-connected Lookup is useful when we need to call the same lookup multiple times in the mapping.

Answer Question  Select Best Answer

prav2000

 Profile Answers by prav2000 Questions by prav2000

• Dec 21st, 2006

Majority of the times the DataWareHouse core tables are in a 3NF form and this is where your entity relationship comes into picture.Further you can have fact and dimension tables which are populated using the core tables. The fact and dimension tables follow the star schema or snow flake schema.

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

Entity is nothing but an object usually it is table containing the attributes(columns)ETL is a tool not a modeling .. it's useful for transfrering the data from the sources (hetogeniuos) to the targ...

Answer Question  Select Best Answer

noverino

 Profile Answers by noverino Questions by noverino

• Feb 23rd, 2007

Push strategies:   - ETL waiting notification for data would be processed. If the notification contain     no data to be processed, ETL must retrieve itself to the source.   -...

prav2000

 Profile Answers by prav2000 Questions by prav2000

• Dec 21st, 2006

Push and Pull strategies determine how data comes from source system to ETL server.Push : In this case the Source system pushes data i.e.(sends data) to the ETL server.Pull : In this case the ETL server pulls data i.e.(gets data) from the source system.

Answer Question  Select Best Answer

SQLGal

 Profile Answers by SQLGal Questions by SQLGal

• Jun 7th, 2009

The simple answer is, when it is cost effective.? ETL tools save time but can be expensive.??They are more?efficient than writing code?because the?code is built using drag and drop.??These cod...

Rambabu.Gali

• Nov 26th, 2007

We should go for an ETL tool when we have to extract the data from multiple source systems like flat file, oracle , COBOL etc at one instance. where PL/SQL or SQL can not fit.2. we can update the targ...

Answer Question  Select Best Answer

mhollingsworth

 Profile Answers by mhollingsworth Questions by mhollingsworth

• Aug 24th, 2010

[source data (files or whatever)] --> read & parse --> sanitize and format --> [staging area] --> transform --> load --> [data warehouse] --> generate reports   

jaggu_mandya

 Profile Answers by jaggu_mandya Questions by jaggu_mandya

• Jan 18th, 2008

(sources)---------->Staging Area(Transformation)---->Target------>Interface-->ReportsData baseFlat filecobol fileXML file

Answer Question  Select Best Answer

What is the first one executed in a session? Is it the Truncate Target Table option or the Post SQL? Explain

Mamta11

 Profile Answers by Mamta11 Questions by Mamta11

• Oct 14th, 2008

Truncate table will be executed first.Trunc. table gets esecuted before the table starts loading and post SQL executes after the session is completed (table loaded)

nova84

 Profile Answers by nova84 Questions by nova84

• Jun 23rd, 2008

Truncate Target table:Integration Service truncate target tables before running a session.Depending on the target database and primary key-foreign key relationships in the session target, the Integra...

Answer Question  Select Best Answer

What are some typical considerations during the data cleansing phase

SQLGal

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

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

Answer Question  Select Best Answer

What are the different tools available for Data Extraction

cyberdiptikanta

 Profile Answers by cyberdiptikanta Questions by cyberdiptikanta

• Jul 26th, 2010

1.Informatica2.Datastage3.Ab-intio4.Oracle Warehouse Builder5.Oracle Data Integrator6.SSIS

smsreddy

 Profile Answers by smsreddy Questions by smsreddy

• May 20th, 2009

Instead of Extraction we can say Intigration tools ( ETLs) some of those areInformaticaDatastageSASMicrosoft SSISOracle Warehouse Builder

Answer Question  Select Best Answer

As an ETL tester what are the things to test in Informatica tool. What are the types of testing has to do in informatica and the things to test in each type? If there is any documents on ETL testing

lakshmi

• Jan 31st, 2013

ETL Testing in Informatica: 1. First check the workflow exist in specified folder. 2. Run the workflow. If the workflow is success then check the target table is loaded on proper data else we can nee...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Feb 18th, 2012

- Test ETL software. - Test ETL datawarehouse components. - Executing backend data-driven test. - Create, design and execute test plans, test harnesses and test cases. - Identify, troubleshoot and pro...

Answer Question  Select Best Answer

while moving data from source to target
in source there 1000 records and in target there 990 records
how would u find that mismatch occured in particular column

Manoj

• Sep 7th, 2015

The Basic logic is E-R=T (SRC records - Rejected Records are equal to Target)
Suppose SRC has 1000 records and target has 990 records then rest of the 10 records should flown into Rejection
In some scenarios aggregated records could be extracted in the target those case amounts should be validate

etllearn

• Mar 11th, 2015

Minus between source and target table

Answer Question  Select Best Answer

Primary key should not allow null values.But still we are checking primary key null check in ETL Testing.Why?

Pooja B.

• Oct 11th, 2015

Because sometimes on database level the column (Primary key) is not defined as primary key, so in that case we need to check primary key for null values in ETL testing.

Sumit M. Jha

• Apr 28th, 2015

Primary key in the table is the unique identifier and is used to map the data. So, if primary key is null; then data cant be mapped with other table.

Answer Question  Select Best Answer

Any One please explain me roles and resposibilities of ETL testers as well as explain me his work from starting point to end point in ETL testing Thanks..

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Jan 25th, 2017

As an ETL Tester you need to know - What is the purpose of the ETL jobs that you are testing(whether you are loading data into the table or writing data into intermediate files which will be loaded l...

Deepti

• Jan 5th, 2017

ETL Testing Process Steps 1. Understand the end to end design. 2. Test Plan Preparation. 3. Test Scenario Preparation (optional) 4. Preparing the test queries to perform the following validations: &nb...

Answer Question  Select Best Answer

What will be the output (Number of records) for below operators.
Table A has one column with values(1,1,2,2,2,3,4,5)
Table B has one column with values (1,1,1,2,2,3)
1. A Union B
2. A Intersection B
3. (A Union B) minus (A Intersection B)
4. A minus B
5. A Left Join B
6. A Right join B
7. A Inner...

Chinmaya

• Aug 8th, 2019

1.12345
2.123
3.45
4.45
5.ID ID_1

1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2
2 2
2 2
2 2
2 2
3 3
5
4

6.ID ID_1

2 2
2 2
2 2
2 2
3 3
1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2

7.inner join
ID ID_1

1 1
1 1
1 1
1 1
1 1
1 1
2 2
2 2
2 2
2 2
2 2
2 2
3 3

Prince Jain

• Apr 8th, 2016

1.12345
2.123
3.45
4.45

Answer Question  Select Best Answer

How will you test if your source system and target system in different database.

Adarsh Srivastava

• Aug 26th, 2016

Create DB Link to connect source and target DB servers. Use blink in conjugation with the table name to execute both source and target query in same server (either source or target)

sekhar

• Aug 1st, 2016

If the source and target are different databases then you can copy the both databases data in excel sheet, and you can compare based on you can use macros and use excel formulas.

Answer Question  Select Best Answer

I got the following mapping table and asked me to validate source to target the ETL mapping using Single SQL query. How can we validate source to target the ETL mapping using Single SQL query? I need help to write a query.

Source to Target Mapping Document
Target Table Target Column Source Table Source Column Transformation rule ( ....)
TRG_LOG LOG_KEY ...

swpna

• Jun 17th, 2019

By using minus query (column mapping between source and target

Deepti

• Jan 5th, 2017

Write separate queries as shown below and join by union. Here, it is assumed that LOG_KEY is the key to join both the tables. This way we can know what is the validation that failed and the for which ...

Answer Question  Select Best Answer

I just want to know more about landing area in Datawarehouse
Why landing area required in DWH ?
Diff between landing area and staging area in DWH ?

Suresh Reddy

• Sep 29th, 2017

Landing Area or Landing zone:
This area is used to bring data from multiple source to single zone (say like ODS).
Staging area:
In this area, logics are applied on the data by creating views.

Jasmeet Sahni

• Jan 30th, 2017

Landing area - is the area where we kept the source files from where the ETL tool will be going to extract the data.

Staging area is the initial stage of the database where we just load the load into table without applying any transformation or business rules.

Answer Question  Select Best Answer