DSXchange

you cannot perform an update action on a sequential file, if your requirement needs it use hash file, in place of sequential file.

Thanx a lot,
the only missing thing was, stage variable.

I want to write into a hash file some, default/constant values(I will be hardcoding this in transformer stage), So we can say that no input stage is passing data to transformer stage. Trans ----> Hashfile Can I have a design like above without having any primary input stage? well while compilation i...

Hey thnx,

I got that done, none of the users where "actually" accessing that project at that time. But one of the job was locked internally, due to which index rebuilding was failing. So i just cleaned up the resources and did it again.

One of our guys tried to rebuild index "DS.REINDEX ALL" Through DS Admin. Since then, we are unable to see the jobs in that project, on the DS designer pallete or in manager or dir. I am not sure that it happened due to that or some other thing. Few unusual thing. 1. While opening job, if ...

Wondering if anyone has any suggestions for getting a job to generate a warning if there are no rows returned from the source. Ideally I don't want to do this from a controlling job, but within the job at runtime? I have tried a constraint on INROWNUM [color=red]but the job seems to complete succes...

its again lost/vanished , its testing my patience...

A small correction to first code... I dont know how that happened, in some places there is reference to index "Output<i>", after pasting it in the thread I can see only Output. :( [img] Replace:: if Trim(Output) <> '' Then OpenSeq LogFilePath:Output To FileVar Then With: if Trim(Output<i>)...

In the Job Sequence. JobA ---->JobB(actually a Routine). here is the routine if You need it. RestartabilitySqlldr(ORACLE_HOME,UserName,DataBaseName,UserPassword,ControlFilePath,ControlFileName,DataFilePath,DataFileName,LogFilePath,LogFileName,BadFilePath,BadFileName,Parallel,SkipUnusableIndexes,Skip...

Well I have done bit of R&D on this, and the fastest way i found was, the logic is only for Fact load, it can be modified and can be adopted for dimension: In JobA I read from a sequential file, in the transformer stage i do error check, data validation, data massaging stuff and then instead of ...

Simple solution, without adding any extra stage: Goto Job Properties -->Performance Tab --> you will see Use project defaults box ticked, uncheck that and tick "Enable Row Buffer" ---> Tick Inter process radio button. set the buffer size in accordance with your data or you can also keep it...

hi, Well this piece of code will tell you if a string contains a non numeric and a non alphabetic character. If Iconv(Oconv(Arg1,"MC/N"),"MC/A") matches "~0A" :char(253):"~0N" Then Ans='String contains special characters :' :Iconv(Oconv(Arg1,"MC/N"),...

Its an oracle error error code ORA-01008: not all variables bound
Cause: You tried to execute an SQL statement that contained substitution variables where all variables were not bound.
If you just want to delete 2005 records, you can give,
Delete from <tablename> where year=2005

Hi Nripendra, Using of job parameters in a decode statement wont throw any error. I feel that your are not calling the parameter properly. say I have declared a parameter, DeleteFlag with Default value as 'Y' then my sql will look like: select decode(col1,#DeleteFlag#,'YES','NO') from <table_name>

your incoming string must be containing multiple SPACES, so first TRIM it and then try either your own old method or any of the method suggested in the previous two threads.