How did you reconcile source with target?

Answer Posted / bi etl

selct count(*) from source table;

selct count(*) from target table;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are system variables and sequencers in datastage

617


Can you explain link buffering?

732


To see hidden files in LINIX?

948


What is the difference between informatica and datastage?

662


Describe link sort?

657






What are the functionalities of link collector?

633


What are the primary usages of datastage tool?

629


What is the difference between orabulk and bcp stages?

586


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1055


Triggers,VIEW,Procedures

806


What are the job parameters?

717


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1145


Different ways a project can be moved to production ?...example ….export-import and Version control.

1944


Whats difference betweeen operational data stage (ods) and data warehouse?

677


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1764