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.

Define oconv () and iconv () functions in datastage?

0 Answers  

---

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

3 Answers   IBM,

---

What are system variables and sequencers in datastage

0 Answers  

---

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,

---

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

0 Answers  

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

What is the project in datastage?

0 Answers  

---

how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,

---

How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,

---

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

---

Is the value of staging variable stored temporarily or permanently?

0 Answers  

---