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

What is aggtorec restructure operator?

1456

---

What are orabulk and bcp stages?

1128

---

How do you start developing a datastage project?

1113

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2024

---

What is the difference between odbc and drs stage?

1093

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2085

---

How will you move hashed file from one location to another location?

2154

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460

---

In Datastage, how you can fix the truncated data error?

1162

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2633

---

Name the third party tools that can be used in datastage?

1078

---

Define ds designer?

1285

---

Differentiate between datastage and datastage tx?

1057

---

what is repositery?

1846

---

Give an idea of system variables.

1037

---