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.

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.

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

---

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

2 Answers  

---

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---

What are the different common services in datastage?

0 Answers  

---

What is the difference between lookup and sparse lookup?

1 Answers  

---