DSXchange

Improper data type

As chulett suggested we should first know what the other scenario is doing ?

Is it having any numerical calculation on any of the varchars or chars? (asking because the jobname suggests some kind of calculation involved)

You can use Microsoft's ODBC Driver for Excel for this.

But I would prefer to do it by converting it into the csv then using using the csv as a sequential file.

You can use dsjob command line tool.

First select the rows with order by level desc Next from the source to a transformer. Create a Stage Variable named MaxDepth having derivation as if(@INROWNUM=1) then SrcLink.Level Else MaxDepth In derivation for Lowest if(SrcLink.Level=0) then 'Y' Else 'N' In derivation for Highest if(SrcLink.Level...

Ya Chulett,
Missed that.
Thanks for correcting.

at the prompt execute

path=[[drive:]path[;...]];

Or using DSExecute first execute "cd pathlocation" (where sqlplus is present.).

After running that job it is observed that the first file loads firstly and 2nd after that That is not i want How do you know that? What about replacing your source file with a table (just to see if that is troubling(for a test))? Try KeyMgtGetNextValueConcurrent() routine, does that make any diffe...

No, this is not an issue. And I don't think setting the transaction size to 1 is good for performance?

With the update action Insert new rows or update existing rows the commit frequency gets automatically set to 1.

This means your source records are duplicated in such a way that it conflicts with one of the unique index present on the fact table. check the count of the records on the columns part of the index. Say if you have index1(col1,col2) on fact table then check select col1,col2,count(*) from srctable gr...

Use Parameters in place of the Hardcoded File names. Its pretty straight forwad.

is there any constraint present on number of job activities tht can start at same time. No, until unless they don't have any resource conflicts (like writing to sequential files, table locks, transaction locks). Or it exceeds the parameter limits, like number of Hashed file opened at a time. And, o...

"-d -s" : #$DBName# : "-x ABC -u" : #$DBUser# : "-p" : #$DBPass# : ",
d -s" : #$DBName# : "-x LMN -u" : #$DBUser# : "-p" : #$DBPass#

Use : operator to concate strings. That should work fine.

Prior to uservariable you can run a job which reads from the sequential file and places the contents on the $UserStatus of the comma separated string, then you can use this $userstatus within the Expression Field of the user variables.

While Logging in i am using computer name as host name and username and password i am omiting by checking omit check box.

Specify username and password and then try logging in, it should work for you.

I guess this is something that you need to specify at the time of ODBC connection creation (DSN creation).