Answer Posted / dileep

Hi This is Dileep,

Take one Sequential File, One Copy Stage and Put 5 O/P Links to Sequential Files.

From Sequential File, Map Directly to Copy Stage and to Sequential Stage.

In the target Sequential File, In the "Options", One 'Filter' Option is there. In that... Put the Condition like the below..
1 O/P---- head -2
2 O/P---- head -4| tail -2
3 O/P---- head -6| tail -2
4 O/P---- head -8| tail -2
5 O/P---- tail -2.
Similarly U can achieve this in Datastage by Using the Debug Stages 'Head' and 'Tail'. Precondition is to Run the Job on 'Single Node' or 'Sequentially'.

What is the difference between validated and compiled in the datastage?

1217

---

What is the difference between orabulk and bcp stages?

984

---

What are the partitioning techniques available in link partitioner?

2240

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2229

---

Describe the architecture of datastage?

969

---

What is staging variable?

1040

---

Explain datastage architecture?

1347

---

What steps should be taken to improve Datastage jobs?

1016

---

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?

2139

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2851

---

Lookup constraints

1207

---

Name the different sorting methods in datastage.

1002

---

What is apt_config in datastage?

1094

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2772

---

What are the types of hashed files in data stage

1073

---