DSXchange

Hi,
The GUI.
New Stages/functionality.
Connectivity enhancements

Do you really need the whole detailed list?

Hi, If you can get a file/table/another spread sheet inside the excel file with info regarding from which row to read which sheet, then you might have a better automated solution, setting a constraint in the transformer to pass only records bigger then the parameter rows to skip. In any case you nee...

Hi, To add on what Kim said. I opened an oficial support call once regarding a bug with the ussage analisys and the response was something like yes we reproduced this behaviour, but, since metastage is the tool for this kind of info use it instead of ussage anlisys. In short no chance anyone will fi...

Hi,
This was covered not long ago
please search for this topic.

So why post in the EE forum ?

Hi, Yes, Use search in the forum to get the exact solution. It was covered so many a time Or simply go thru the help Or study the existing routines/transforms and modify them to your needs. Use @DATE and @TIME for a stable time stamp for all inserted rows Or Use Date() and Time() for a current times...

Hi,
Definitly sounds like a bug to me.

I'm not sure there are many EE users using windows yet.
I do believe there might be more once it supports NLS.
In any case please post a follow up once you have this resolved with your support provider.

Hi,
look at the join,merge stages
I think you will find that a lookup is probably the fastest way.

IHTH,

Hi and welcome aboard ,
Try setting the extended property of this column in the table definition to unicode.

IHTH,

Hi, I don't exactly understand your reason for wanting this but it depends on what is your source, here are 2 examples: 1. A sequential file has a "read first rows" option for reading n number of rows (you can use a parameter as value) 2. An Oracle stage can use a where part constraining n rows (als...

Hi,
My guess is using 1 of:
- additional connection options
- open command
In the enterprise stage.
As for the syntax I'll need to get a DBA's answer.
I'll try testing it.

IHTH,

Hi All, I have a situation where DB tables have some numeric columns defined as number , with no sacle/precision defined. DS imports their definition as decimal(38,10) due to lack of info, which causes some problems like: writing an 7 digit number to a data set gives a decimal(38,10) number with lea...

Hi,
If you need to validate prior to inserting the rows to the DB you must verify them.
If not you might be able to pull it off using a reject link and some post load handling of the rejected rows.

IHTH,

Hi,
depending on the exact logic you could do this using multy value columns in a hash file or an ODBC stage defining a multy reference in the transformer stage's input link.

IHTH,

Hi,
to add on what craig said.
you can also have some controll if you'll use a user defined syntax.

IHTH,