DSXchange

Hi BOB,

Earlier i was using DISTINCT in query itself but was taking more time. So i am doing it in DS itself.

Hi Chullet,

I am just using the below query
select
Field1
from Table

And taking distinct value using sort stage as its huge data.
Job is first reading data from Oracle stage and then passing to sort stage and not using pipelining.
Also please tell me where to use @FALSE constraint.

Hi All,

Still help is needed.

Problem is i have 90M record in my oracle table. While extracting it is reading appx 10K record per sec and taking 2.5 hrs. Please suggest how can i increase extraction rate.

Hi, I am trying to extract data from oracle table using oracle connector. execution mode is default parallel. When i am setting Enable partitioned reads option yes and giving partitioning read method as rowid hash, sql giving more no of records rather than if i keep Enable partitioned reads option a...

Hi Kumar,

Can you please explain how did you achieve this?
I am also facing the same issue.

I got the issue.
After running the job was checking the job status as
STATUS=`dsjob -jobinfo $ds_project $ds_seq
checking with the value 1 or 2, while it will be always 99.

i updated the script as

STATUS=`dsjob -jobinfo $ds_project $ds_seq.$Inv_Id

which worked fine.

Hi, I have to process four file with same meta data. i have created one px and one seq job with multiple instance feature to perform this. i am calling this multiple ins seq by four diff script as there some more checks on the same file needs to be performed. My issue is when these scripts calls the...

Yeah.. but didn't work as expected

Nothing worked out.

Finally had to split the job and create separate update and insert job

Thanks all for your suggestions.

chulett wrote:So these duplicates... do have the duplicates in the file itself, or is there just a single instance of the key value in the file which may or may not exist in the table? The answer changes how you need to handle this.

We have duplicate key values in file itself.

yes, in tfm its auto and in connector its hash partition.

there is no such requirement which need to be updated.

No Its not a primary key. Its coming in file itself. an may come as duplicate.
that's the reason i want to use update then insert.

I have to load date field in oracle table,It loading as 1900 base while i need to load in 2000 base. eg current output Input -> Output 07-23-01 -> 07/23/1901 desired output 07-23-01 -> 07/23/2001 I am using StringToDate(inputfield ,"%mm-%dd-%yy") function. Please advise how to fix this.

Hi, I have below seq Job design JobActivity -> User variable activity -> cond Check -> notification I need to send mail if there is any reject In user variable i am using below function Result = DSGetLinkInfo (JobHandle, StageName, LinkName, InfoType) DSGetLinkInfo (Job_StdRrcWklySplit.$JobName, 'Tf...

Thanks djbarham,

It worked for me, :D