DSXchange

Use convert or ereplace function in the transformer to remove "-" character from the input date like following

One basic question related to hash file: In which scenario should we set Pre-load file to Memory-Enabled. I mean to say, is it wise to set above property when hash file is big? In my case, in the sequence jobs are running parallel and some of the jobs using hash files as well. Need to know best prac...

rafik2k wrote:Use

Code: Select all

Oconv((Iconv(Arg1,"D-YMD")),"D-YMD[4,2,2]")

function to convert it into db2 date format.

Where Arg1= COLL_DT

Use function to convert it into db2 date format.

WoMaWil wrote:Hi Rafik from 2nd (k)lasse,

you cannot load or change parameters after your job is started. That you will learn in future in 3rd (k)lasse.

What you can do is:

Write a sequence

I didn't get you. Could you clearify the same.

BTW what's (k)lasse????

Hi All, Can anyone of you give hints how to read parameter from csv file. I have value like this Parameter name value etl_run_date '2004-05-01' etl_run_date '2005-05-01' etl_run_date '2006-05-01' etl_run_date '2007-05-01' For first run, i want to use first parameter value, for second run i want to u...

Create a server routine,
specify its type as Before/After subroutine from drop down menu.


once you compile it, it will be available after job subroutine in the Job properties page

Create one after job subroutine

use the basic function to get rowcount passing through the each links.

Result= , Give InfoType as DSJ.LINKROWCOUNT

Compare the result and call DSLogInfo to log the custom message.

If you don't want use sort stage, then treat the unsorted table as dummy table. Create another new table with the same structure.

Select all columns from dummy table as order by clause in asc or desc and pass as it is into target new table.

Is your job parallel or server? 0 means it is not finding "." in the input string. For server job, try writing small subroutine and check like findDot Position = Index(Arg1, ".", 1) Ans = Position call the subroutine in column derivation of occurance as findDot(file_name), though...

How complex is transformation rule in TFM2 and TFM3?
May be complex rule is eating your speed.

How complex is transformation rule in TFM2 and TFM3?
May be complex rule is eating your speed.

I am still confused in your requirement. If need all records from inventory and their corresponding matching records from master table? if yes then your following sql will work perfect. select pinv.*,pdesc.description from product_description pdesc, product_inventory pinv where pdesc.pcode = pinv.pc...

While creating hash file from table, create pcode as key.

In transformer join both table using pcode.

Just drag pcode from primary link and drop it into derivation of reference link in the transformer.
Then pass required column into outpu link

DSguru2B wrote:Same thing

DS Guru Ji,
You need zoom lens to check that