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 flat file and using unix how can i generate sequence number into targer?
can we half project in parallel jobs and half project in server jobs?
what is the definitions for Datawarehose and Datamart?
HOW CAN WE SEE THE DATA IN DATASET?
What is exact difference between Parallel Jobs and server Jobs..
What can we do with datastage director?
What is exact difference between Parallel Jobs and server Jobs..
explain unit testing,systemtesting,integrated testing
explain about citrix scheduling tool in datastage
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
how to sort two columns in single job in datastage.
1.what is materialized data? 2.how to view the materialized data?