Redbrick

narsi1111 · Post by **narsi1111** » Tue Jan 16, 2007 7:34 am

I created a job with input as sequential file and do a bulk load in one of the tables in redbrick database. So, I used the option of Redbrick bulk load stage with the option Load Automatically = Y. The job runs without any errors. But in the database, but it's creating .bat files and .dat files and it's not creating TMU files

Expecting the reply at the earliest.
Thanx in Advance

DSguru2B · Post by **DSguru2B** » Tue Jan 16, 2007 7:41 am

Welcome Aboard

Confirm this for me, does the data get loaded or not? Also, the control files will be created in the directory you provided in "Control File Directory" property. Also, what is the file name that you are providing, if you are not providing any name it will default to table_name.tmu

narsi1111 · Post by **narsi1111** » Tue Jan 16, 2007 7:48 am

yeah it's loading the data into table but it's not genrating tmu files under Control File Directory. even i tried without passing Control File Directory
in this case it's genrating .dat files and .dat files not tmu files .

Thanks

narsi1111 · Post by **narsi1111** » Tue Jan 16, 2007 7:48 am

yeah it's loading the data into table but it's not genrating tmu files under Control File Directory. even i tried without passing Control File Directory
in this case it's genrating .dat files and .dat files not tmu files .

Thanks

DSguru2B · Post by **DSguru2B** » Tue Jan 16, 2007 7:54 am

Check for that file in your default project directory. Maybe its sitting there somewhere. Also, did you provide 'Y' for the property "Remove intermediate data file"? Try with 'N'.
If nothing works then set Load Automatically to 'N' and then go to the control file directory and see if it really gets created there or not.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 16, 2007 7:38 pm

If "remove automatically" is set to Yes, the TMU file is removed once the load has occurred.

narsi1111 · Post by **narsi1111** » Wed Jan 17, 2007 12:38 am

HI
If i not pass Custom Control File Name it's genrating tmu file with the name of databasename_inputtablename.tmu
but i pass Custom Control File Name it's not genrating TMU file but it's genrating all files such as .bat,.sql,.dat

please can u help me

Thanks

narsi1111 · Post by **narsi1111** » Wed Jan 17, 2007 1:08 am

Hi

I put Remove intermediate data file =N even it's not genrating TMU file

Thanks

DSguru2B · Post by **DSguru2B** » Wed Jan 17, 2007 10:33 am

are you providing the fully qualified name. Try giving it with quotes. See if that works. The file is getting created, otherwise how is the data being loaded.

narsi1111 · Post by **narsi1111** » Thu Jan 18, 2007 8:57 am

no buddy i got the answer if you wants pass user defined name for tmu file. in that case first run the job without passing any name for tmu it will genrate default name. and rename that file which name u want and use that name in u r job and run it it will creating tmu file. it means it's should expect tmu structure in the control directory.

DSguru2B · Post by **DSguru2B** » Thu Jan 18, 2007 9:13 am

Thanks for sharing the solution. You can mark your post as resolved.