DSXchange

I changed the data type to Decimal in source. But still warnings are comingI am using a scale of 1. Shall I use scale in my source and all other transformer stages following it or is it just enough if I change in source (OCI stage). Is there any range of scale values I have to use or its simply tria...

I figured out that there are four amount columns in my job which are cuasing this error. Acc_DR -->1000, 2987.76 Acc_CR---->291.13, Null(just empty space) Entered_DR-->234.09,23 Entered_CR-->459.09,-900.20 and all the above four are numeric data type with length of 38 in the SOURCE and TARGET. I man...

I am trying to extract a large volume of data. When I run the job for 1000 records, it is running fine. But when I run it for more than 1000 it is running but with a warning " OCI has fetched truncated data" I encountered this error before when I was loading the data year wise. I thought, ...

Ray,

In ur reply "Do it afterwards, so that you don't slow the job itself. "

Afterwards means in the target stage I should start populating my audit table. Or is something else you were mentioning about

Right now I am trying to build an audit table which consists of the following information: 1) Batch number of the daily run 2) Extraction start time 3) Extraction end time 4) Time elapsed SO where to insert this link in the job and how to populate these columns. This table will be an ouput link from...

I think running multiple instances will be better in terms of performance. So I am opting for it

This is for keeping track of errors. This is a good practice for reconciliation and also to know what errors are present and how to reprocess them.
I did not build one until one.
I need to get more clear picture of how to build it and populate it

Thanks for all your ideas. I am actually using two date job parameters as LoadDate and LastLoadDate. My where clause is like Creation_Date Between LastLoadDate and LoadDate So now using Sequence and 6 job activities my where clause in the main job will be something like Extract year from Creation_Dt...

Hi I am trying to run my Job as Multiple instances.. I developed a job sequence with six instances of the job. I am trying to partition the data on time stamp. I am having a create_date in my source data. So I am trying to use a job parameter to which I can assign a year and in the main job's WHERE ...

Hi

What is an Error Processing table and Audit table.
Plz let me know the concept behind these tables.
How these tables could be built?

Hello Everyone

Wish U all A Happy and Prosperous New Year 2007

Thanks all of you for your ideas.

I got the answer with the second choice mentioned by Narasimha and Criag.

Thx once again

one intersting thing is happening when I mention the Trigger condition as you mentioned in first set. Execute_Command_12.$CommandOutput=0 Execute_Command_12.$CommandOutput=1 ie" I am not getting any email" I gave the output links to 2 notification activities. I am not getting nay email now...

Yes Narasimha,

I am getting 1

I am getting the following log in the director:

Executed: cat /Ascential/DataStage/Projects/filename
Reply=0
Output from command ====>
0

Executed command: /Ascential/DataStage/Projects/sendmail_Jseq_Routine_Test76201_4368.sh
*** No output from command **