1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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 / guest

Answers were Sorted based on User's Feedback



i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this..

Answer / thippareddy.p

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

Is This Answer Correct ?    18 Yes 2 No

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this..

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.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

How to reverse the string using SQL?

0 Answers   CTS,

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

what r the sources u need to create the datastage?

1 Answers  




can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

Explain how a source file is populated?

0 Answers  

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

tell me abt Datastage trigger?

1 Answers   HP, IBM,

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

For more Data Stage Interview Questions Click Here
Categories