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

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

navaneethvr

 Profile Answers by navaneethvr Questions by navaneethvr

• Jun 9th, 2009

In the Designer, you can create mapping variables in a mapping or mapplet. After you create a mapping variable, it appears in the Expression Editor. You can then use it in any expression in the mappin...

Praveen

• Aug 14th, 2005

  After creating a variable, we can use it in any expression in a mapping or a mapplet. Als they can be used in source qualifier filter, user defined joins or extract overrides and in expres...

Answer Question  Select Best Answer

Abhijit Jagtap

• Jul 12th, 2007

You can Oracle PL/SQL stored procedure from Informatica using the STORED PROCEDURE Transformation. But it needs ODBC connection. You can pass the parameters to the stored procedure through a mapping. There are two ways :-1. Stand alone2. in the mapping flow.

rajesh

• Jul 14th, 2005

We can use External Procedure Transformation to use external procedures. Both COM and Informatica Procedures are supported using External procedure Transformation

Answer Question  Select Best Answer

dvs

• Nov 5th, 2005

draw the inference if slowly changing dimension and based on the Type 1/2 or3  tables defined.

Andy

• Aug 23rd, 2005

When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current mth) or a transaction flag (e.g. Ord...

Answer Question  Select Best Answer

anjanroy

 Profile Answers by anjanroy Questions by anjanroy

• Apr 14th, 2006

You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.

paddy

• Dec 6th, 2005

Sq is a connected transform. cant do it.

Answer Question  Select Best Answer

Monark

• Jul 28th, 2006

IDP is the portal for display of reports, stored process, information maps and a whole bunch of thing ideally required for a dashboard reporting.IMS, is the gui to help u convert ur technical data and map it to business data (change names, add filters, add new columns etc)

Ram

• Jul 18th, 2006

In SAS what is Information Delivery Portal and Information Map StudioRegards,Ram

Answer Question  Select Best Answer

Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Feb 22nd, 2007

Update strategy, Supposed you have a router you are router has 3 groups, 1 group is for update, 1 group is for delete, 1 group is for insert to target table.  You can use the update strategy for ...

Rangini vignesh

• Aug 29th, 2006

Ans:We can use Update strategy transformation in two ways .1.Mapping level.2.session level.Importence of Update strategy transformation in both cases as follows.In real time if we want to update the e...

Answer Question  Select Best Answer

jyothi_rayala

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

Answer Question  Select Best Answer

In BO Data integrator, metadata repository is in
A. Relational DB
B. File System (XML)
C. Proprietary Format

sonivx

 Profile Answers by sonivx Questions by sonivx

• Jun 16th, 2011

Relational Database

sixersiddu

 Profile Answers by sixersiddu Questions by sixersiddu

• Apr 3rd, 2010

Answer is A. It will be present in a Relational database.

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Normally ETL Tool stands for Extraction Transformation Loader This helps you to extract the data from different ODS/Database, If you have a requirement like this you need to get the ETL tools, else you no need any ETLCheers,Sithu

Praveen

• Aug 14th, 2005

ETL Tools are meant to extract, transform and load the data into Data Warehouse for decision making. Before the evolution of ETL Tools, the above mentioned ETL process was done manually by using SQL c...

Answer Question  Select Best Answer

The DW database can be Oracle or Teradata. The requirement here is to pull data from source system and ETL need to device a mechanism to identify the changes or new records. The source system can be a legacy system like AS400 application or Mainframe application. List out all such methods of data capture. The ETL can be Informatica, data stage or custom etl code.

Sriram

• Jul 13th, 2007

Assuming this is a Type1 Dimension or a FACT table on the DWH - Create Date and Update Date will be 2 system dates captured and stored on the Datawarehouse. First time Creation_Dt = Update_Dt.&nb...

Answer Question  Select Best Answer

Doyel Ghosh Dutta

• Sep 16th, 2011

I think in microstrategy view can be reusable object.

Answer Question  Select Best Answer

srinivas vadlakonda

• Oct 17th, 2006

If u r taking connected we return the more than one port, in this we can use the static and dynamic cache and it will support the user defined values.If u r taking unconnected we return the only one port it will support only oracle with this we can use dynamic cache not static.

rajkumar

• Oct 10th, 2006

If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.

Answer Question  Select Best Answer

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

Stop on errors=1 (if you set this option to 1 the session will be stopped after occurance of 1 error row. if it is 0 the  session will not be stopped even u got n number of errors.

Answer Question  Select Best Answer

sriluck

 Profile Answers by sriluck Questions by sriluck

• Mar 3rd, 2008

Global shortcuts are across multiple repositories,Local shortcuts are across multiple folders in the same repository.

Answer Question  Select Best Answer

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

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

Answer Question  Select Best Answer