1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

How did you reconcile source with target?

Question Posted / ram

Answers were Sorted based on User's Feedback



How did you reconcile source with target?..

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

How did you reconcile source with target?..

Answer / bi etl

selct count(*) from source table;

selct count(*) from target table;

Is This Answer Correct ?    1 Yes 0 No

How did you reconcile source with target?..

Answer / vaibhav gupta

For reconcilation of date You can use tool 'WinMerge'

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

how to sort two columns in single job in datastage.

0 Answers   TCS,

CHANGE CAPTURE

0 Answers   CTS,

tell me abt Datastage trigger?

1 Answers   HP, IBM,

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,




ename like ibm,tcs,hcl need display those records only how?

2 Answers  

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,

DataStage Scenario based Interview Questions

1 Answers  

how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,

what are the different type of errors in datastage?

2 Answers   Wipro,

Define meta stage?

0 Answers  

what is the use of skid in reporting?

0 Answers   NTT Data,

For more Data Stage Interview Questions Click Here
Categories