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 |
wt is the diff b/w odbc and oracle stage
Describe link sort?
can explain wt is the pool for file.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
what is parameterset?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
What are transforms and what is the differenece between routines and transforms?
How can we run same job in 1 day 2 times
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
What are some different alternative commands associated with "dsjob"?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?