How did you reconcile source with target?

Answers were Sorted based on User's Feedback



How did you reconcile source with target?..

Answer / hemachandra

If you want to prepare Reconciliation report source with
target use the datastage internal function DSGetLinkInfo.
This function will show you how many records extracted from
source link and how many records loaded into target link.

Is This Answer Correct ?    6 Yes 0 No

How did you reconcile source with target?..

Answer / bi etl

selct count(*) from source table;

selct count(*) from target table;

Is This Answer Correct ?    1 Yes 0 No

How did you reconcile source with target?..

Answer / vaibhav gupta

For reconcilation of date You can use tool 'WinMerge'

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is the difference between orabulk and bcp stages?

0 Answers  


1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


Can you explain link buffering?

0 Answers  


If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,


client know skid info?

0 Answers   NTT Data,






Define Data Stage?

0 Answers  


What is the difference between lookup and sparse lookup?

1 Answers  


how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,


input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,


how many types of remove the duplicate records?

3 Answers   Caterpillar,


I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  


Categories