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

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  


EXPLAIN SCD

0 Answers   CTS,


iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,


How do you design PX Routines ?

1 Answers  


Nls stands for what in datastage?

0 Answers  


Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,


How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,


CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  


Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,


What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,


How can u write exception handling in seq file????

2 Answers   IBM,


How to manage date conversion in Datastage?

0 Answers  


Categories