DSXchange

Hi All, i have a requirement i.e; i am generating a text file with a column named - "SEQNO" & other column is " BUSS UNIT" there are three rows for the output file and i want the following data for the three rows . the first row for the column - "SEQNO" is 00009999 ...

Ok,i will check any null values for the Col 4 - 'STP'

Hi, when i do the mapping 1-1,i can view the data.in fact the data for the Column 3 -TXN is 'Null' for 3 rows and remaining 8 rows there are values for that Column. But when i concatenate then why i am not able to see the Column 4 - STP for txn ===>Null,But i can see the Col 4 for the remaining 8 ro...

Hi ,

i used the peek stage and still i am not able to get the Column 4 - 'STP' populated.

Hi All, My path is as Following : DataSet(the Dataset Comes from an Extract Job) =====> Transformer =====> Seq File i am generating a sample text file,i have Four columns in the file i.e; SEQ,REC,TXN,STP & there are total of 11 Rows. the Column "TXN" has Null Values for 3 rows,so i am ...

Thanks a lot Eric...

Hi All, i am having the path as following : DATA SET=======>TRANSFORMER=============>SEQUENTIAL FILE My question i have some 25 rows of data in the dataset,and i am doing some logic in the transformer and when i write the output in the Sequential File i am getting the Rows i.e; Output data in a Rand...

i used the preserve option in the Aggregator and now i can get the max time- stamp written in the file.

Hi chulett,

thanks for your reply...

Works Fine...

Hi , i am having several Current time stamps from an extract query... Now i want to get the latest timestamp -CTS from the Pool of the Current time stamps... Here is what My path looks like : ODBC =====>COPY========>AGGREGATOR======>Seq file in Aggregator when i select the Max output column -CTS the...

Hi SEKAR,

i am checking the Data/time Functions in the transformer & i could find CurrentTimestamp() but not CurrentTimestampMS()

Hi,

i want to use in the transformer Directly,there is no Database connected.
so is there any way i can use in the transformer rather than taking from the Database.

Hi ,
i need to capture the current time stamp,so please help me what is the code to use...


i need the time stamp in millisecs..

Hi,
thank you for the reply..

i am going to try it...lets Hope it works...

i am getting the timestamp for each row,for example : i/p has 10 lines of data then i am geting 10 lines of timestamp (all are similar) and the timestamp is the time when the job run..

Now my Question is i want to extract the timestamp,when there is no I/P data.