Interested to Buy Any Domain ? << Click Here >> for more details...
How did you reconcile source with target?
- 3 Answers
- 16867 Views
- HP, I also Faced
- E-Mail Answers
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 |
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is the difference between lookup and sparse lookup?
Which algorithm you used for your hashfile?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
Explain Quality stage?
Is possible to create skid in dim,fact tables?
What is quality stage?
what is repositery?
What are the different options associated with dsjob command?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
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?
Teradata 
