Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

if we using two sources having same meta data and how to
check the data in two sources
is same or not? and if the data is not same i want to abort
the job ?how we can do this?

Question Posted / eswar


if we using two sources having same meta data and how to check the data in two sources is same or ..

Answer / subhash

SeqFile1----->|
.................|ChangeCapture--->Transformer--->TGT
SeqFile2----->|

SeqFile1 & SeqFile2 are the inputs to Change Capture.
From the output Change Capture Stage we one extra column
‘Change Code’.
If, the record is same in both file, i.e. Copy Record.
Change Code=0
If, the record is only in SeqFile1, i.e. insert Record.
Change Code=1
If, the record is only in SeqFile2, i.e. delete Record.
Change Code=2
If, the record is in both files but with some modifications,
i.e. edit/update Record. Change Code=3

If all Change are '0' then 2 files having same Data.

In the transformer constraints, we can mention as ‘ change
code <>0’ then set ‘Abort After Rows’ to ‘1’.

Is This Answer Correct ?    9 Yes 2 No

Post New Answer

More Data Stage Interview Questions

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

Describe link sort?

0 Answers  

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 Answers  

How to add zero "0" before record in a field?

4 Answers  

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

What are the stages in datastage?

0 Answers  

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

What can we do with datastage director?

0 Answers  

how do u reduce warnings

1 Answers   CGI,

For more Data Stage Interview Questions Click Here
Categories