DSXchange

Hi Folks Source is a decimal(17,4) target is Varchar(50) . values in the decimal input can be negative . In the target leading '0' to be trimmed and 2 decimals are needed after point(.). For positive integers TRIM does the trick , but stuck up with negative decimals(since start char is a '-' sign) T...

Hi, I am using an Oracle Enterprise stage in Upsert-Insert mode to insert records into an oracle table. The fields in the input record to the oracle stage can have leading or trailing spaces in them. When I used the Load-Append option, the operator variable APT_ORACLE_PRESERVE_BLANKS (false) is able...

Hi , Create 3 stage variables using the functions as mentioned below.. Str('0',2-Len(Field(linkname.columnname,'/',1))):Field(linkname.columnname,'/',1) --- stage variable 1 column name -- column in which u have the date in the varchar format Str('0',2-Len(Field(linkname.columnname,'/',2))):Field(li...

Job getting aborted with the Following error message main_program: APT_PipeConnection: new connection 1 requests file descriptor -1, which was also requested by connection 0 main_program: Fatal Error: Incompatible connection - operator type = APT_OSL_SubprocOperator What does these error messages in...

Can anyone provide me some Good Material on Custom & Wrapped stage Creation and Usage like any link or books .............?????

I have created a wrapped stage with sort operator which is given in the Paralled job advanced developer's guide with two datasets as input and the sorted output to be stored in a dataset but the job keeps on running with no warnings in director logs but seems like no data is coming out from the Wrap...

We are in process of designing a new ETL process here. Our requirement is to extract messages from MQ and post it to destination URL by making an HTTP post. The extract job will be scheduled and the job should pick up all the messages in the queue in one go and then do the data transformation and do...

Thanks cullet. If any one knows more about this option, do share it with me, even if it is very small point.

Hi all,

Can anybody tell what does the validate option under execution action in the job activity stage of the sequencer validates. How is this option useful?

Thanks in advance,
Ram.

Arnd,

Can you please post the result of the job run today. Do you observe any data integrity issues. Does the size of the output dataset reduce from 400GB.

Thanks,
Ravish.

Thanks Ray. But in production the volume is going to be in the order of few hundred million. So i was thinking that adding a transformer stage and trim() with in could potentially affect my performance. So i did: 1. Added a copy stage between the sequential file stage and the dataset stage. 2. Mappe...

Hi, I have a job that reads records from a CSV flat file. The source has four fields each of which is defined as varchar(250). The records read from the file are written to a dataset. The column length in the dataset is also varchar(250). The dataset file is currently consuming 1KB to store each rec...

Absolutely right about what? Are you talking about daylight savings days? What database are you using? Try investigating what functionality the database offers with regard to DST changes. If there is nothing built in create a Calendar table with attributes that specify if a day is a short, long or ...

Hamzaq

You can use a CAT statement in the shellscript (Execute command activity) and get that to the next job

I have a sample where i do

cat <filename>|head -1

and get that to my next job .

What are the components in your Job ? ODBC stage ? How does your Job Design look like ?