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

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 ?

1623

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

657

---

What is the project in datastage?

664

---

What can we do with datastage director?

666

---

Explain ibm infosphere information server and highlight its main features?

606

---

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2052

---

Define APT_CONFIG in Datastage?

662

---

How do you generate sequence number in datastage?

623

---

What all are the different way to run a job?

639

---

What is quality stage?

568

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

665

---

How can we improve performance of data stage jobs?

612

---

Difference between in process and inter process?

695

---

What is the different type of jobs in datastage?

568

---

Why do you need stage variables?

658

---