DSXchange

Hi Team, I am facing issue in Sequence jobs. my job contains execute command stage --------------> notification activity stage when i ran the job i am getting below issues Warning : the Attempting to Cleanup after ABORT raised in job <job name>..JobControl Control : Job <Job name> aborted.

Hi, In my job i am using the Surrogate_Key_Generator stage when i run first time the sequence values are getting properly like 1,2,3,4 but when i run second time with one more new insert record i am getting 1,2,3,4,6 not as 5. for every run it is skipping one sequence value. first run: source ------...

Hi, In my project i am getting the error while view data of sequential file as below. error: <node_node1> Player 1 terminated unexpectedly. <main_program> APT_PMsectionLeader(1, node1), player 1 -Unexpected termination by Unix signal 6(SIGABRT). Note: sequential file is .txt please help me.

Hi Datastage team, i have one field contain the varchar data type(but contain integer value) i want output value should be starts with zero then numbers. example: input: 2347689 output: 02347689 how can i pass the zero value in front of the integer value. or how to convert this. please let me know.

Hi, Lookup stage by default AUTO Partition but internally it executes in ENTIRE Partition. I have 4 records in my source and reference also same 4 records. when I Run the job with AUTO Partition in Lookup with 2 nodes i got 4 records(2 in 1st node and 2 in 2nd node) but same job with ENTIRE Partitio...

Hi,

In my project i have more than 4 xls sheets how can import all these sheets
at a time(one stage only). it is possible to import or not?

If possible based on which stage i can import the xls sheets.

please let me know.

arvind_ds wrote:Try this one.

date_from_timestamp(EnterYourTimeStampFieldHere)

Hi arvind,

where is date_from_timestamp in transformer functions.

Hi,

How to get Date from Timestamp in Transformer.


please let me give your suggestions.

Hi,


Thanks to all for giving valuable information.

yes i got exact result what i expected by using

SecondsSinceFromTimestamp and TimeFromMidnightSeconds

once again thanks to chulett, and BI-RMA

Hi BI-RMA,

thanks your suggestion but i am getting negative integer values but i want correct Time format in output.

Hi I Have source contain two fields current time(timestamp) and previous time(timestamp) my target field Differ_Time(Time) example: Input previous time,current time 2005-04-25 17:25:43,2005-04-25 18:25:43 Output: Differ_Time 1:00:00 what function i have to use in Transformer for this . please help me.

Hi peddakkagari,

i am not getting output results but virtual data showing records. in output dataset have no columns .

Hi, i am using date and time functions in transformer 8.5 as below one PreviousWeekdayFromDate(CurrentDate(),"tuesday") that is current date is 30-08-2011. but i am getting the output result is 2011-08-30 it's not giving Previous Weekday. Note: my doubt is it's giving same date what i ente...

Use this formula.

[@Partition number + (@INROWNUM-1)*@NUMBER PARTITIONS+1]

Hi, i have one scenario. i have 12 files that is Jan_file,Feb_file,mar_file,APR_file......Dec_file. Jan_file Id,Sal,month 1,100,Jan 2,200,Jan 3,300,Jan when ever query the Jan_file i am getting these 3 Records. Feb_file id,Sal,Month 1,100,Jan 2,200,Jan 3,300,Jan 3-1,400,Feb In this when ever i query...