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.

Where do you see different stages in the designer?

0 Answers  

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

What are the types of jobs we have in datastage?

0 Answers  

---

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

---

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

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

6 Answers   Syntel, TCS,

---

What is a quality stage in datastage tool?

0 Answers  

---

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

---