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

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

2219

---

why do u need the IOS upgradation in a FC switch

2239

---

Where do you see different stages in the designer?

1051

---

What is the difference between orabulk and bcp stages?

986

---

What is the differentiate between data file and descriptor file?

1319

---

Difference between sequential file and data set?

1155

---

what is ds administrator used for?

1130

---

How many types of views are there in a datastage director?

1249

---

How to convert RGB Value to Hexadecimal values in datastage?

3948

---

Define meta stage?

1158

---

What are the types of views in datastage director?

1731

---

Where the datastage stored his repository?

1036

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1082

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2148

---

What are data elements?

1122

---