How did you reconcile source with target?

Question Posted / ram

3 Answers
16921 Views
HP, I also Faced
E-Mail Answers

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

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers Tech Mahindra,

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

5 Answers IBM,

Define oconv () and iconv () functions in datastage?

0 Answers

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers EDS,

what is normalization and denormalization

2 Answers CTS,

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers Alpharithm Technologies,

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers TCS,

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers MGL,

What are the types of jobs we have in datastage?

0 Answers

For more Data Stage Interview Questions Click Here