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.

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

---

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

How a server job can be converted to a parallel job?

0 Answers  

---

What are the types of containers in datastage?

0 Answers  

---

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,

---

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

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,

---