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

i have the source from Uk,north america how can i pass the
data two tables based on the locations

Question Posted / ravik.datastage

Answers were Sorted based on User's Feedback



i have the source from Uk,north america how can i pass the data two tables based on the locations..

Answer / shar

question incomplete.

but still we can differentiate recs of uk & america.
we can use col gen and assign a small code(uk/us) to rec(s) of each table and funnel them if they have same metadata and do the processing thing and load the processed rec(s) to target depending upon the business requirements.

However guys plz provide basic details in questions so that proper answer can be given.

Is This Answer Correct ?    1 Yes 0 No

i have the source from Uk,north america how can i pass the data two tables based on the locations..

Answer / pooja

Basically the question is incomplete and not clear.

Based upon my understanding, we can consider country codes
for the records if location is the main criteria which are
unique for every country and can be processed further.

What exactly needs to be done with the records is not
stated in the question.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How can u write exception handling in seq file????

2 Answers   IBM,

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

what is set mapping in datastage??

2 Answers   ADP,

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

what is the use of surogate key in datastage

3 Answers  

What all are the different way to run a job?

0 Answers  

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

Define meta stage?

0 Answers  

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?

2 Answers  

For more Data Stage Interview Questions Click Here
Categories