DSXchange

Hi, We have a set of queries in a table as follows. For example Group ID SQL Query 1 Select * from table11 1 Select * from table12 1 Select * from table13 2 Select * from table21 2 Select * from table22 2 Select * from table23 2 Select * from table24 3 Select * from table31 3 Select * from table32 C...

Hi,

We have installed dot net 2003 and its resolved our problem.

Thanks to everyone.

Hi, We have re-installed Datastage but the problem is still persists. This time we are getting the error message as follows: Output from transformer compilation follows: ##I TFCN 000001 13:55:13(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascentia...

Hi All, We have installed Datastage PX 7.5.2x recently. We developed some sample jobs and the jobs are working fine if we don't use Transformer stage. When we are creating a job with Transformer stage, during compilation we are facing the below error. Output from transformer compilation follows: ##I...

Shiva, Your jobe design should look like this: TGT_TBL--------------->Hashfile | | | Src_Tbl------------------->Transformer----------->TGT_TBL Each time Datastage will load all the TGT_TBL contents to Hashfile first and then Src_Tbl will do lookup on that hash file.

Shiva,

Load your target table TGT_TBL into Hash file and do lookup on that.

Goto Start Menu--> Programs-->Ascential Datastage-->Online Manuals-->Datastage Documentation..

You will find all the documents related to datastage here.

Hi Rimi,

You will get all the information about routines in BASIC reference manual which is available in Online manuals. Go through that you will get idea.

Also search the forum if you got any doubts, lot of posts are available about routines.

Munish,

You can do as per the Balaji's suggesstion. Where are you getting struggled? In the column properties you can mention as follows:

Hope this will help you to resolve your problem.

Hi,

In the Triggers tab, just click the 'Unconditional' option. Then it will go to the next job without worrying about the status of the current job.

Hi, I think you are in wrong way. Are you hardcoding the metadata? If yes, this is not a good practice to do so. Always it is better to import the meta data through Datastage Manager is the good way. length precision for a decimal value wth length as 9 and precision 2, i shuld define in datastage as...

Hi,

In the warning message it is given that,

or is too large for the destination decimal

so plz check the datatype and size in your target. This might be the reason...

Did you tried with the function 'StringToDecimal'? Is it giving the same warnings?

Hi, APT_CombinedOperatorController,0: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal. Is your input column having any decimal values? If it is, then you can go for the function 'StringToDecimal'. (Since y...

Sayam,

But you posted in Server Edition forum.
Plz mention your correct input format whether is it 2006346 or 106346 as per Srinaths post. I think the correct Julian day format is 106346.
Plz try with the function
"DateFromJulianDay"

Hope this will help you...

Hi,

Try with Field Function. This will give you only the date part, so you can store it in a table.

Hope this will help you.