Answer Posted / solomon

2 ways to do it
1- input -> Transformer -> RDP-> output
Sort the input on location, company
do a comparison in Stage Variable with prev record and keep incrementing a counter
pass it via Remove duplicate stage to retain unique records
2- input-> copy-> agrregator-> lookup-> RDP -> output
do the same as above using agg and lookup stage

What are the types of jobs we have in datastage?

1019

---

What is the flow of loading data into fact & dimensional tables?

1011

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1091

---

Define Job control?

1059

---

What can we do with datastage director?

1161

---

Describe routines in datastage? Enlist various types of routines.

954

---

To see hidden files in LINIX?

1449

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1439

---

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?

2128

---

How and where you used hash file?

1105

---

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?

2549

---

What is apt_config in datastage?

1081

---

What is difference between symmetric multiprocessing and massive parallel processing?

1078

---

Explain Quality stage?

1085

---

What are the functionalities of link partitioner and link collector?

947

---