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.

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

---

Tell me the syntax of Configuration file?

1 Answers  

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

What can we do with datastage director?

0 Answers  

---

how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,

---

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,

---

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,

---

What is the use of datastage designer?

0 Answers  

---

What is meta stage?

0 Answers  

---

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

---