Answer Posted / vinod upputuri

First use the seq filestage then use the copy stage after
the copy stage one link is going to agregator stage there we
will calculate the count of records after the agregator
stage use filter stage for finding uniq records then those
records are connected to the lookup as a reference link. the
main link for lookup is comming from copy stage. Then
matching records are uniq else duplicate.

Agre--->filter
| |
Seq--->copy---->Lookup---->uniq
|
|
duplicate.

In agregator use count rows.

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

841

---

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

3566

---

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

1663

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2088

---

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

2127

---

---

CHANGE CAPTURE

902

---

How rejected rows are managed in datastage?

928

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1753

---

What is the difference between informatica and datastage?

660

---

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

2999

---

Explain ibm infosphere information server and highlight its main features?

615

---

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

671

---

What could be a data source system?

581

---

How to find value from a column in a dataset?

1773

---

what is use of SDR function?

4716

---