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 orabulk and bcp stages?
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?
Can you explain link buffering?
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 ?
client know skid info?
Define Data Stage?
What is the difference between lookup and sparse lookup?
how can we create rank using datastage?what is the meaning of rank?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
how many types of remove the duplicate records?
I have a few records just I want to store data in to targets cycling way how?
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