Answer Posted / ramu

src.....>agg........>t/r..........2trgs
take src as seqfiles and take aggregater stage is for
calculate count of records based on name coloumn,next take
the transformer is for apply constraints like cnt=1 then go
for trg1

What is the difference between server job and parallel jobs?

1094

---

Name the different sorting methods in datastage.

991

---

How one source columns or rows to be loaded in to two different tables?

1072

---

What are the functionalities of link partitioner?

974

---

To see hidden files in LINIX?

1454

---

Can you explain players in datastage?

1144

---

what is ds administrator used for?

1113

---

On which interface you will be working as a developer?

988

---

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

1069

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2407

---

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

---

Does datastage support slowly changing dimensions ?

1054

---

how to add a new records into source?

1937

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2105

---

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

3934

---