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 |
If you want to use the same piece of code in different jobs, how will you achieve it?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
How and where you used hash file?
Define repository tables in datastage?
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
How to move data set from one server to other?what are the steps to follow to do this?
What are the stages in datastage?
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
what is the use of surogate key in datastage
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....