How did you reconcile source with target?
Answers were Sorted based on User's Feedback
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 |
Answer / bi etl
selct count(*) from source table;
selct count(*) from target table;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vaibhav gupta
For reconcilation of date You can use tool 'WinMerge'
Is This Answer Correct ? | 0 Yes | 0 No |
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
EXPLAIN SCD
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..
How do you design PX Routines ?
Nls stands for what in datastage?
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)
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
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.
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
How can u write exception handling in seq file????
How to manage date conversion in Datastage?