Answer / thippareddy.p

if (drawtime)< 13 then drawtime=drawtime+12 else drawtime

Answer / subbuchamala

SRC--->Transformer--->TGT

In the TFM Output Columns Derivations:


(HoursFromTime((MyLnk.drawtime:"00"))+12): MinutesFromTime(MyLnk.drawtime)--->OutputColumn

(MyLnk.drawtime:"00")--->Convert Source Format to %hh:%nn:%ss
(HoursFromTime((MyLnk.drawtime:"00"))+12)--->Adding 12 hours to hours from source and Concatanating with Minutes from Source.

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

---

options available in sequence job to run,validate?

0 Answers   CTS,

---

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

---

count number of deptno in a emp table?

2 Answers   IBM,

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

what is set mapping in datastage??

2 Answers   ADP,

---

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

---

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,

---

Can you explain kafka connector?

0 Answers  

---

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

---