SRC--->Transformer--->TGT In the TFM Output Columns Derivations:

i have source like
balance,drawtime
20000, 8.30
50000,10.20
3000,4.00

i want target like this
balance,drawtime
20000, 20.30
50000,22.20
3000,16.00

Question Posted / subbuchamala

2 Answers
6759 Views
I also Faced
E-Mail Answers

Answer Posted / 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.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you explain engine tier in information server?

1109

What is the difference between the local container and shared container?

1082

Explain the importance of surrogate key in data warehousing?

1171

What are the steps needed to create a simple basic datastage job?

1216

What is the difference between passive stage and active stage?

1507

Explain datastage architecture?

1383

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

1944

Differentiate between data file and descriptor file?

1031

What are data elements?

1156

how to export or import the jobs in .ISX file

1181

Can you filter data in hashed file?

3760

What is data partitioning?

1178

How can we improve the performance in datastage?

1090

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2472

What are iconv and oconv?

1223