DSXchange

Hi DSLearner, For two job activities success triggers use the following condition JobActivityName.$JobStatus= 1 or JobActivityName.$JobStatus= 2 (Job is finished or finished with warnings) Use the Unconditional Trigger for the routine activites so that the log file is written both for success and fa...

Hi Arvind, I would advise you to search this forum for CDC stage. The CDC stage is the best stage for delta loads. The CDC stage has 4 options for Drop Out and in your case you can define Drop Out for Insert = False and Drop Out for Delete/Edit/Copy = True. The delta file will have only new records....

Hi Nripendra Chand,

The Modify stage uses orchestrate functions. It will not accept string functions used in the transformer. Pls make sure what functions are available in the orchestrate manual for these kind of operations.

Moreover, you cannot apply two functions in the derivation.

HTH
--Rich

Hi Craig,

I have used the following syntax in my ETL jobs and it works fine. Thats why I suggested it eventhough it seems equivalent. Lets wait for dsedi's response.

--Rich

Hi dsedi,

The following syntax should get you through

col1 : Str(" ", 20 - Len(col1)): col2

HTH
--Rich

Hi Nripendra Chand,

Use the following conversion. You should be through.

Trim(Field(DecimalToString(INPUT_COLUMN),".",1))

HTH
--Rich

Hi,

Pls do a search. It has been discussed already. Even last week there was a post. The search is available as a link at the top of the DSXchange screen.

Pls click the following link

--Rich

Hi Kumar,

In the copy stage set Preserve Partitioning to Clear and run the job. The warning will disappear.

HTH
--Rich

Hi Nripendra Chand, Try to output the value of the stage variable without doing the StringToDate Conversion. You will find that there will a leading space to the string and the last character truncated(A weird behaviour) I hope you are using DecimalToString(input_column) as the derivation for stage ...

Hi Ravi, I have come across these errors when the 1. Configuration file is not defined properly 2. Stages variables have some logical problems 3. Environment Variables defined as Job parameters are used without proper conversion You are using 2 output links but the second output link does not have a...

Hi Nripendra,

The advantage of dataset is that it can store persistent data. It stores a NULL only as NULL and not 0.

If you want to handle null and provide some other value in the dataset other than 0 then use Transformer(NullToValue) or a Modify stage(handle_null).

HTH
Rich

Hi DSLearner, 1. Create a dummy row with columns for Header and Trailer using a row generator. 2. Use the DB stage to get the detail records. 3. Use a Transformer with 2 output links, one to pass the records and other to an aggregator to find the count. 4. Use a lookup stage to pass the record count...

Searching the forum will yield faster results on different methodologies used for generating sakeys.

We use the column generator, the transformer and the DB stage to generate surrogate keys. Pls search the forum.

HTH
Rich

Hi Jack,

Instead of doing from the Administrator client add the $APT_DUMP_SCORE environment variable to your job parameters and set the default value to 1. It will give you the required information.

HTH
Rich

Hi Ray,

I have used both rm and delete commands and it seems to work well. Is there any difference?

I will also check from my end.

TIA
Rich