Answer / Chetan Prakash

Server Jobs and Parallel Jobs are concepts used in Data Stage for running jobs. Server Job refers to a single instance of a job that runs on a Data Stage server, whereas Parallel Jobs involve splitting the same job into multiple instances (parallel threads) to speed up processing by distributing the workload across multiple servers.

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

---

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

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)

1 Answers   IBM,

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

---

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?

1 Answers   IBM,

---