What are the validations you perform after data loads for source to target?

Suresh Reddy

• Sep 29th, 2017

Once the data is loaded in the target tables, we have to do below validations:
1. Counts between source and Target
2. Duplicates check
3. Null Values check
4. Mandatory Values check
5. Data compare (source minus Target and Target minus source)

ashokkumar

• Jul 5th, 2017

Such this type of testing is carried out to validate the data whether source data is transformed to expected target or not and also check the values.

Answer Question  Select Best Answer

What are Initial Load validations and Incremental load validations ?

Bedanta Hazarika

• Sep 23rd, 2017

Initial or Fresh load refers to the state where we truncate or delete all the records from target table and do a fresh load of Data from source. Whereas in incremental load we update the old record...

ashokkumar

• Jul 5th, 2017

Initial load means when ever the target tables are empty that time we are going to load the data from starting year up to this day data loading into data warehouse or data mart is called initial load....

Answer Question  Select Best Answer

What is the other way to mapping the columns without using MINUS

BASAVARAJ Hunshal

• Oct 17th, 2020

Intersect

Or

Full outer join with not null on both tables

pavan

• Oct 26th, 2018

Left join

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 14th, 2006

Yes it supports 6.1.3 on words

ravi kumar guturi

• Mar 10th, 2006

yes, But it supports only in 7.1

Answer Question  Select Best Answer

dtennes

 Profile Answers by dtennes Questions by dtennes

• Jun 9th, 2009

You cannot use Informatica to extract data from SAP via ABAP.  Only the SAP/Business Objects Data Integrator product can do this.Informatica uses a data dictionary interface, with clear SQL instr...

rasmi

 Profile Answers by rasmi Questions by rasmi

• Apr 3rd, 2008

Hi,We can extract SAP data by using informatica with the powerConnect option.We need to install and configure the powerConnect tool . Import the Source in to the Source Analyzer. Here PowerConnect is ...

Answer Question  Select Best Answer

njvijay

 Profile Answers by njvijay Questions by njvijay

• May 12th, 2008

Need to have reconciliation strategy to very input and output data with reject counts

Anil

• Nov 9th, 2006

Hi, u can check out the session logfiles for the total number of records added number of records udated and number of rejected records and errors related to that so this is the answer the interviewer is expecting from usk

Answer Question  Select Best Answer

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

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

Answer Question  Select Best Answer

jryan999

 Profile Answers by jryan999 Questions by jryan999

• May 1st, 2008

A Materialized View is just that.  A view which has been materialized to become a "table". The big difference between a View and a Materialized View, is a View executes a query on-t...

naresh sharma

• Nov 2nd, 2006

Materliazed view log is for audit trail purpose on table. This concept was introcuded in Oracle 9. Thsi will help to trace the record based on it's dml operation.

Answer Question  Select Best Answer

jryan999

 Profile Answers by jryan999 Questions by jryan999

• May 1st, 2008

You need Lookup Transformations because Dimension Tables are linked to Fact tables by Surrogate Keys.   The Surrogate Key is automatically generated within the warehouse, and the ONLY way to f...

Naresh

• Oct 5th, 2006

  Look Up Transformation is generally used when a fixed data is not present in the mappings we use but is required in the ware house or look up is more importantly used to compare the values...ex...

Answer Question  Select Best Answer

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

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

Answer Question  Select Best Answer

what are the roles and responsibilities of an ETL developer/designer/team lead?

Ragupathi

• Apr 19th, 2015

ETL Developer roles and responsibilities are 1.Understand the etl specifications and build the etl applications like Mappings on daily basis 2.Need to fetch the daily data from various sources like...

SQLGal

 Profile Answers by SQLGal Questions by SQLGal

• Jun 7th, 2009

The ETL developer's responsibility is to ensure that the goals of the business with regards to data management are met.  The developer should be able to design and implement a plan for a...

Answer Question  Select Best Answer

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 controlling

32kris

 Profile Answers by 32kris Questions by 32kris

• Aug 11th, 2010

Cleaning is required as it helps in maintaining the uniforminty of the target data.

Answer Question  Select Best Answer

Uttam22

 Profile Answers by Uttam22 Questions by Uttam22

• Feb 21st, 2014

A ETL Tester primarily test source data extraction, business transformation logic and target table loading . There are so many tasks involved for doing the same , which are given below - 1. Stage tab...

radhakrishna

• Nov 4th, 2013

ETL tester responsibilities are: writing sql queries for various scenarios like count test, primary key test, duplicate test, attribute test, default check, technical data quality, business data qua...

Answer Question  Select Best Answer

How to select the Even and Odd records in SQL server and in Oracle without using ROWNUM,ROWID

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Jan 30th, 2017

"oracle8 TO SELCT EVEN RECORDS IN ORACLE : ----------------------------------------------- SELECT CUSTOMERID FROM (SELECT CUSTIMERID, CASE WHEN MOD(CUSTOMERID,2)=0 THEN EVE...

MUKUL MALIK

• Aug 22nd, 2016

SELECT customerid,case when customerID %2=0 then even
when customerID %2 < > 0 then odd end as result from customers

Answer Question  Select Best Answer

How to find number of duplicate records?

Swathi

• Sep 26th, 2017

We can find the duplicates using SQL Query.

Code
 

Harsha

• Jun 10th, 2016

Code
 

Answer Question  Select Best Answer

Source have phone number with 8 digit and target has 10 digit. How to test target phone number has 10 digit start from +91?

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Jan 30th, 2017

First Thing: If phone_num is type numeric, + is not allowed. Second Thing: If phone_num is varchar, and the length of the phone_num is 8 in source, if you want +91 to be appended in the beginning the ...

Naushad

• May 17th, 2016

Code
 

Answer Question  Select Best Answer

What are the T/Rs which create cache files?

sowjanya

• Oct 21st, 2014

Sorter,lookup,joiner,rank,aggregator

deepthi

• Aug 20th, 2011

Aggregator
joiner
lookup
rank
sorter

Answer Question  Select Best Answer

butair

 Profile Answers by butair Questions by butair

• Aug 3rd, 2009

Client:-* GUI/Presentation logic* Query specification* Data Analysis* Report formatting* Data accessApplication/Data Mart Server:-* Summarizing* Filtering* Meta Data* Multidimensional view* Data accessDW Server:-* Data logic* Data services* Meta data* File services

shayona

 Profile Answers by shayona Questions by shayona

• Jun 1st, 2009

Three tier data warehouse contains three layer. 1st layer does all the data extraction and 2nd layer does transformation and in 3rd layer there is loading of clear data.

Answer Question  Select Best Answer

sathya

• Oct 10th, 2006

1)ETL Tools IBM Websphere Information Integration(Ascential Datastage) Ab Initio Informatica2)OLAP ToolsBusiness ObjectsCognosHyperionMicrosoft Analysis ServicesMicrostrategy3)Reporting ToolsBusiness Objects(Crystal Reports)CognosActuate

rockky

• Aug 7th, 2006

There is also Group 1's Sagent. Excellent ETL tool along with some aspects of BI as well.

Answer Question  Select Best Answer

Salman Baig

• Aug 17th, 2014

Partitioning is a technique which partitions data across several disks and exploits bandwidth of disks by storing and retrieving in parallel.It reduces the time required to perform the access of data ...

DWH01

 Profile Answers by DWH01 Questions by DWH01

• Jul 9th, 2008

Oracle provides partitioning of Tables, Indexes and IOTs to split their contents into different partitions.  Each partition could be on a separate physical drive.  This provides faster perfo...

Answer Question  Select Best Answer