DSXchange

Great Thanks chulett, I have tried it. It's working fine.But the file is having the latest record.Is there any property to set "Append the File" If i gave the input File as... Input File :Product.txt Product_name Region Level Sales A Adc 1 2300$ A Adb 1 2300$ A Ad1 1 2300$ A Ad2 1 2300$ B ...

narasimha, It should be like this Input File :Product.txt Product_name Region Level Sales A Adc 1 2300$ A Adb 1 2300$ A Ad1 1 2300$ A Ad2 1 2300$ B Adc 1 2300$ B Adb 1 2300$ B Ad1 1 2300$ B Ad2 1 2300$ C Adc 1 2300$ C Adb 1 2300$ C Ad1 1 2300$ C Ad2 1 2300$ I want the out put as 3 files: Out Put Fil...

Ray,

The count of the products are not Defined, It is dynamic.If we get 60 products we have to split as 60 files with product name as the file name.We may get more than 100 products also.Is there any solution with out implementing using loop.

Hi, My source will have left outer join with target to get the target surrogate key.If the CDC columns are changed for that Natural Key ..I am inserting one New record with New surrogate Key and Updating the old Record based on the Sk column.As i mentioned earlier it's a row by row commit and Groupe...

Hi, My source will have left outer join with target to get the target surrogate key.If the CDC columns are changed for that Natural Key ..I am inserting one New record with New surrogate Key and Updating the old Record based on the Sk column.As i mentioned earlier it's a row by row commit and Groupe...

Hi, I want to split the Product Sales File, Which is having 100 Products.I have to split that file and store it as 100 Flat files with Product name as the File Name.We are not supposed to use the loop activity to trigger the same job for 100 times.Is there any other way to do it in the same datastag...

Hi, We are facing a peculiar problem in DS. We are using SCD2 job. From the source we are loading in to hash file and from the hash file we are inserting in to target. Its a row by row commit and before inserting we are having oracle stage lookup to generate surrogate key. Our problem is some times ...

Hi Sreeni, Based on the requirement. We can write the VB code which will take the template as the input and generate the DSX as output. For this we have to provide the configuration files such as target table, source table.etc. Based on this it will connect to database and fetch the Meta data and pl...

Hi,
what is Difference between logging text , final text message in terminator stage.Anyhave its a terminator stage and it will be excuted in fraction of second.What is the need for giving two different messages?
thanks,
Siva.G

Hi, We are calling one shellScript stored in param InputArg1 using "Call 'DSU.ExecSH'(InputArg1, result1) " , The shell will exit with different set of exit codes such as 5,4 and i have to capture the return codes and act accordingly.But the "result1" is always having 0 or 1.Will...

yes anupam i am testing in test server only...But in my case i am using loop activity which may trigger all 5 or even one based on my routine output.So the sequencer property ALL wont work here.So is there any other way to achive this.

Anupam, I tried your way,But I want the sequencer to be aborted .But the sequencer is not aborting as per the suggestion made by you.It just throws warning. I have to wait till all the jobs complete and finally check for abort and have to abort the sequencer if any one job aborts.I am also getting o...

Hi ramesh,

How to check for abort /pass?In sequencer stage there is no properties to check for fail.

Hi,

I am not having that document ,Will some one help me on this,Otherwise give link where i can find this document.

Thanks,
Siva.G

Hi,
I am using DS 7.5,I need info on Stored procedure stage.Is it possible to call a function in Stored procedure stage.Bcoz i am returrning some value and i need to capture that...

Will u Heilp me on this.

Thanks,
Siva.G