DSXchange

I also want to understand these statistics (20%).


Thanks guys!

Hi everybody.

Does anybody know the difference between the objects 'Oracle OCI' and 'Oracle Connector'?

Do they work different? When should I use one or the other?
The thing is, I need to load a large amount of data.
PS. I am working with a Server job.

Thank you so much.

Best Regards,

Do their Rules require a hammer to fasten a screw? The idea here is to use the right tool for the task. In this case it's a sequence (and, preferably a server job to read the file). You can update a values file of a parameter set directly, but you have to overwrite the entire file. You could do thi...

You ARE able to use sequences. ... Hi Craig. Actually I asked my customer If I am able to use sequences because of their Rules, you know? Also... They only have Parallel Jobs there and I don't know If I can create Servers. Anyway, I need to know how to set a value to a parameter set. It would be in...

1) Use a Server job to fetch the parameter value. 2) Write the parameter value to the job's USERSTATUS area 3) Assign all downstream job parameter values to $UserStatus from the Server job. Hi everybody. I have the same issue. How do I use a Server job to fetch the parameter value? Thank guys! Best...

Tks Craig, I'll try to understand how to use it. What if I am not able to use Sequences? Is there any other way? - cause I've already noticed that they don't usually use Sequences at the bank. I don't know whether it is allowed or not. I think not. In this case, our pattern is to develop only Parall...

I have done this in the past, but not all in one job. I had a server job build the custom SQL and place it into its user status area. A downstream parallel job receives the entire SQL statement as a ... Ray, thanks for your help. When you say: "...and place it into its user status area", ...

Roland, thanks for your help. Actually I can't split the data cause today the file can have data to insert into 3 tables and tomorrow, for example, there are data to insert into 5 tables. It's dynamic. The tables have different structures and I don't know them. Got it? I know the ID which identifies...

Parallel, Craig.
Tks!

What if I create a File with all SQL Statements that must be executed and inside the ODBC stage tell it to base its Statement at this file?
Is it possible to execute one by one? Does it understand?

Best regards,

The idea is to generate different SQL Statements based on the register.
Thanks for your help!!!

Best regards,

Hello Guys, I need some help. Imagine the following file content: TABLE_NAME;COLUMN;VALUE PRODUCT;'PRODUCT_COD';'999' PRODUCT;'PRODUCT_NAME'; 'ANY NAME' PRODUCT;'QUANTITY';10 PRODUCT;'INPUT_DATE';'2012-01-01' ADDRESS;'STREET_NAME';'ANY NAME' ADDRESS;'ZIPCODE';'999999999' DataStage must to generate t...

Guys, I found the problem.
There is a limitation when it is used data type Float(8) - because its limit is only 15 positions.
It is an SQL Server limitation.

Thank guys!!!!!!!!!

Hello guys. I have a problem. The job is reading a DataSet that contains a Char field but with numeric content. Example of its content: +0000000000000004574759004.0820020000000000000000000 It has 52 positions. This number need to be inserted in a field Float( 8 ) of an SQL Server Database. When we i...

Hi everybody. I would like to have some tips about a case I have in my project. I need to read a database daily, several times per day, and during the day I need to 'append' a file with these data and, when the day changes, the file must be overwritten and then start to 'append' it again. PS. I can'...

Hi.

The parameters are ok. The count is correct and there are only 'input' type.

Tks!

The warning still happens.

Best Regards