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.

how to configure databases through datastage

2 Answers  

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

---

Difference between sequential file and data set?

0 Answers  

---

why we use parameters instead of hard code in datastage

4 Answers   HCL,

---

what is initial load and incremental load

3 Answers   ADP,

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

What is "fatal error/rdbms code 3996" error?

0 Answers  

---

how to convert rows into columns

2 Answers   IBM,

---

How can we achive parallelism

1 Answers   CTS,

---