Answer Posted / chaint

source1(112345) ----- lookup stage- reference lookup
on(source2 output)--reject link(1144) --output(235)
source2(112345) -- sort( get count) -> filter(only unique)

we would require two source..
one original and other only (non repeated records)

we will have a lookup stage with source1 as input and
source2 as reference lookup..
in lookup stage we will have a reject link(1144) non matched
records.. and output will be(235).

Kindly correct me if i m wrong

Define ds designer?

1212

---

What are the benefits of datastage?

1171

---

How to clean the datastage repository?

1068

---

Differentiate between validated and Compiled in the Datastage?

1191

---

which r the connectors used in san?

2138

---

Which commands are used to import and export the datastage jobs?

1358

---

What are the steps needed to create a simple basic datastage job?

1155

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

---

Name the different types of Lookups in Datastage?

1212

---

Demonstrate experience in maintaining quality process standards?

2453

---

How do u convert the columns to rows in datastage?

1138

---

How many Key we can define in remove duplicate stage?

1309

---

What is use Array size in datastage

1716

---

How can you write parallel routines in datastage PX?

973

---

What is quality stage?

937

---