DSXchange

Where are you using the where clause? is it a SQL or is it some other rule ? What exactly are you trying to do in the job here? a bit of detail about job design would help. Till then have a look into the start and end loop activity in the sequence.

the folder TMP should be present at the location, in your case D:\TMP. If not, Create a folder TMP at this location

Ther is an option in oracle stage ( dont remember which it was) which allows to soften such constraints before loading the data. Not sure why do you have these in the actual DWH in the first place!

Well doh ? Ray just put the code on how to do it

Lets try again: Put this is the transformer constraint. The fist parameter depends on your "etc".

My understanding, after fishing through the forum here also, is that mkdbfile is for unix ? P.S i have tried the command DOS /C "mkdbfile F:\MyFolder\FILE_TEST 19" It states the mkdbfile is not a recognised internal or external command. Might be because of the about reason then ? If i foll...

Hi All, Just playing around with the Type 19 hashed file. i have a source file with 4 rows and a two columns with values . 11,a 11,b 12,a 12,b I want these to go in separate files based on the grouping column, say the first one in this case. so two files should be created named 11 and 12 containing ...

i would take your source is oracle ?

read the file by using execute command stage in the sequence and pass these values as job parameters.

both enforce uniqueness to the record although SK is generated for only newly inserted records in the database based on some key columns. In type 2 we simply insert the a new record based on a history handling column rather than updating it. Space would be an issue in type 2 as we are inserting mult...

the performance of a Hash "ed" file and not a hash file depends on a few more factors than just this one. the Hash "ed" and not the hash file creates two files with the extension of .data and .overflow which need to be monitored. if the size of the .overflow file is greater than ...

I just cleared my certification test for DS today. I just wanted to know if there is any site where you can see the list of all certified developers of DataStage along with their countries ?

Many thanks.

Thanks Ray! . it works fine when i specify the path as a parameter and not a hardcorded value. strange ! although when i try to view the data it still doesnt show it to me and still says that no files found on host and then about APT_FileImportOperator. apart from this when i sepcify the file name p...

thanks ray i have done that and it works like a charm when i use specific files and add four files by using file property . i don't know why when i change it to file pattern it's not working with the same files. also i used the property first name column but its giving me the whole path of the file ...

ok i have tried all three of these and it still says the same !!

E:/test/*.txt

E:/test/*.txt

and E:\test/*.txt

what is an APT_FileImportOperator ?????

thanks. stil does'nt work. when i click on view data on seq file stage it gives me this: ##I TOSH 000002 09:31:35(001) <main_program> orchgeneral: loaded ##I TOSH 000002 09:31:35(002) <main_program> orchsort: loaded ##I TOSH 000002 09:31:35(003) <main_program> orchstats: loaded ##W TCOS 000049 09:31...