Answer Posted / mcssrinivas009

we can use random partion concept

how to write server Routine coding?

2063

---

How and where you used hash file?

1113

---

What are the components of ascential data stage?

1113

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2003

---

What is a folder? Difference types of stages?

1104

---

what is the difference between == and eq in UNIX shell scripting?

1422

---

What a datastage macro?

1007

---

What are the different kinds of views available in a datastage director?

974

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1476

---

What is the difference between the local container and shared container?

1043

---

What are constraints and derivations?

1115

---

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

2760

---

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?

2133

---

How do you import and export data into datastage?

1169

---

What is apt_config in datastage?

1084

---