DSXchange

Hi, i do not understand why you need to have full access on a production project. This is quite dangerous! I'm not sure that dsadm has full access to a protected project. I triad with a 7.0 version, it does not work. My opinion : Protecte projects are a good solution. If you want to have fulle acces...

When you generate a SK, unless you sort data after the generation, the last row has got the max value.

After you can merge data and sort the highest value.

The aim of the tail is to reduce volume.

Everybody tells about the aggregator.

But as the surrogate keys are "sorted", a tail command is efficient to get the hihest value!

no.

Moreover, there are examples of .odbc.ini files. follow the instructions, this is quite easy

there is a bug with DaysSinceFromDate...

if the source date is not "constant" ("2000-01-01") but a date from the source flow of the transformer, performance is very poor!

the documentation is updated. follow the instructions.

I 've set up connections several times and it worked. No special problems.

capture the max value of the column with a second output of the transformer!

I'm not quite sure that 0000-00-00.00.00.00.000000 is a valid timstamp.

Have u tried 0001-01-01.00.00.00.000000?

how many rows do you want to read?

i heard that DS 7.5x2 is not an official release.

So far,I 've never seen a company install it on windows for real ETL process.

the Lookup fileset is a fileset.

Can we acces to it via the fileset stage (there is a append option)?

other question :

do you know how to append data to a lookup fileset??

thank you all...

The join is inevitable :

flow : 300 000 rows

ref : 1 000 000 rows

moreover, this is NOT the only project on the server, i'd like to let some RAM avalaible.

right.

a 9i client can connect to a 10g database

Whay co u have to change the order of the parameter?

it doe not have any impact!