Answer Posted / chandrasekhar reddy

First we need to export the all jobs into a single file with .dsx format and prepare one instruction file that file contain jobs exported path,how run the jobs one by one information.

What is the purpose of interprocessor stage in server jobs?

2233

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2384

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2367

---

What is the importance of the exception activity in datastage?

1073

---

Can you explain engine tier in information server?

1135

---

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

2173

---

Can you explain repository tables in datastage?

1408

---

which r the connectors used in san?

2188

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2446

---

How many types of stage?

1179

---

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

2277

---

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

1538

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2063

---

root tree will find which is server job and which is parallel job?

1967

---

Which algorithm you used for your hashfile?

1182

---