DSXchange

Yes. My current job setting is:
Fail on size mismatch=yes
Fail on type mismatch=yes

Is this is a separate connection, additional to when the data is read ?

Craig,

I agree. The data movement in the job is slow too.
However I want to point out that there are some jobs where connection time is around 2 - 3 minutes. Hence the total connection time is slightly more than 100 mins.

Any ideas/ suggestions to improve these timings?

I haven't enabled partitioned reads, because that comes into play after the connection has been setup to source. Currently this source connection is what is taking up most time. I want to improve this. Currently it takes about a min to establish the connection to source (with encryption on), which w...

Thanks Craig. My job design is as follows: ODBC (sqlserver) -----> xfr ------> Netezza connector (select statement) -----> simple mapping-----> Truncate &load to netezza The netezza connector is set for truncate and load. So the message should be for netezza connector. I want the source ODBC to ...

Hi, I have a job where I am using ODBC connector stage as source to read from sql server. In the logs, I see that it connects to the source two times. Why is that so? Isnt ODBC connector stage sequential by default? I have not configured parallel read option. I want to run it in sequential mode. I c...

Previous runtimes are without encryption, i.e with encryption turned off.

Hello, I have around 100 jobs, all simple extract jobs (no filter) to pull data from SQL Server (cloud instance) using ODBC connector. It is a requirement to have a encrypted connection & we are doing this using recommended ODBC driver and settings in DSN. The problem is that jobs are taking pre...

Thanks for the reply Craig. May be I should have phrased the ques better. The problem is that I am not able to reference the environment variable itself. When I click 'create & attach' option from DataConnection object, it allows me to create a parameter set but I cant add any environment variab...

Hello, I am trying to create a data connection object that uses the attached parameter-set. In this parameter-set, I want the password value to come from an environment variable. But I don't see a way to specify it this way. I tried to directly type the name of the environment variable in the passwo...

I wud like to know how can we use a db2 sequence in surrogate key generator and increment it. As stated earlier, I am facing prob. in incrementing it. Would be grateful if anyone can help on this.
Thanks

Does this mean there is no way to directly use a db2 sequence

Hi, I am using surrogate key generator stage to generate incremental number. For this i tried to use a DB2 database sequence. I have specified the sequence name in the 'Source Name' property. The jobs runs fine but the no. doesnt get incremented.. How can we specify 'next value' type of clause to th...

Hi, The src binary file is a fixed length one. Both the header and detail types are of same length. Basically I wnt to separate the header nd read the 'rec-count' field value & thereafter use this to re-concile the number of detail recs following it. From unix side we tried to use 'dd' command b...

Hi, The src binary file is a fixed length one. Both the header and detail types are of same length. Basically I wnt to separate the header nd read the 'rec-count' field value & thereafter use this to re-concile the number of detail recs following it. From unix side we tried to use 'dd' command b...

Hi, My src file is a EBCDIC binary file. I want to skip the first row from this src file and process the rest. Since it is a parallel job, I m not sure if putting constraint @INROWNUM<>1 will work.. I m not able to use UNIX- head command as when I do 'wc -l' for this file it gives count=0. (The file...