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

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

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

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

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

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

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