DSXchange

Hi all. I have encountered a problem with timestamp type. I have a field (with sql type varchar) given by source data as : 2002-01-11-10.04.50.000000. This is a field that showing us the date and time. I have created a job to transform this data to timestamp by using the command : StringToTimestamp(...

The last record which comes from the input will be active in your database. Do u mean we will have all the records with same primary key in the table. However, only the last inserted record is active? To avoid duplicates of the target table have the primary key of the target in the hash file and fi...

Thanks for your reply. Oh, i understand what u were explaning. Actually, i am not mean to update the data in this case. For instance, i am just inserting tha data and happen to have 2 records with the same primary key. If i am using the Oracle stage to insert, we are able to modify the user-defined ...

For example you can configure an Oracle bulk load to disable keys and indexes and rebuild them after all the inserts are done. I have tried this option in loading my data into Oracle database. However, it will not check for duplicates data. For example, if I am having two records with same primary ...

ray.wurload wrote: What you need to do is to provide a mechanism - probably a dataset - containing the "reverse lookup" from the key values that are found in business data and the surrogate keys with which you keyed the dimension table. Can you please explain further on what you mean by &q...

Hi everyone. I have encountered a scenario that need to populate key from dimension table to Fact table. I am wondering is there any good practice that we can use to solve this scenario.

Hope you guys can share your opinions and experience.

Thanks very much in advance.

Hi everyone. I have encountered a scenario that need to populate key from dimension table to Fact table. I am wondering is there any good practice that we can use to solve this scenario.

Hope you guys can share your opinions and experience.

Thanks very much in advance.