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 |
what is the difference between the join and look up explin me one exmple
In Datastage, how you can fix the truncated data error?
How the ipc stage work?
What is the use of datastage director?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
why do we need a datawarehouse when we have databases to store data?
What is the importance of the exception activity in datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How many types of views are there in a datastage director?
Explain the importance of surrogate key in data warehousing?
How to add zero "0" before record in a field?
what about data stage requirement