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 lookup stage reject link and merge stage reject link in datastage Parallel jobs?
Define APT_CONFIG in Datastage?
What are the different types of lookups in datastage?
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
how does work server jobs?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok
How to read multiple files using a single datastage job if files have the same metadata?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
Define data aggregation?
how to retrive the max(sal),deptno,empno in datastage?
How many jobs in ur project? Explain any complex job u have done in ur project?