DSXchange

I would like to load just date, time is not required, it is going to insert date, now what your suggestion for this call @date in stage variable and then call the stagevariable while loadign every record, thats what I did and it could not be loaded my question is now do I need to use Oconv and I con...

Hi, My database oracle 9 and A filed is defined as of TIMESTAMP(6), while loading a record, I want to load system date in to this filed, could some one help on this, I tried @date, Date(), but it dint help, with out this filed data is being loaded in to table perfectly, now I want to load system dat...

Hi, I job by XFMLoad(MultipleInstances) In the designer I see it as XFMLOAD, but in director I see it as XFMLOAD_AZ, XFMLOAD_CO, XFMLOAD_NV How to define this condition as multiple instances, if i make changes to XFMLOAD will the changes be seen in all the three instances? could some please explain ...

Hi I am getting zipped file and its attached .mkr file as my flatfile source, the files are huge and it taking lot of time to load, for testing purpose, I would like break the file in small fiels and loadthem and test them, if the test is successful then i want to load the full file, is there a way ...

Do we have any option to select the out execution order --------link1------------- XFM -------link2--------------ora ---------link3------------- I have three link from transformer to ora, if have an execution order set the order link1, link2, link3 does the insertion happen in the same order actuall...

Hi,
I am using ora9 to load my data to oracle, how to incorporate control break logic to figure out DELETE then INSERT

thanks

Hi, I am having an flat file in fixed width format how could I find from this from what width to what width the a particular field is do the person who created it have to tell me or is thare any other method, I am new to flat files second question is how could we find how many records are present in...

Hi
what could this possiblly mean, this hashfile is used for lookup else where, to check change data capture
any input would be appreciated

thanks

Hi,
I had imported a read only job from production, I have make changes to it and send it back to production, my question is how to uncheck this read only option so that i can make changes to this job in development

Hi, I had created a server job, and i had mapped a field to a record, but later on it was found that that mapping is not correct and it was changed, this is brought through an hash file but the problem, when i run this job individually, tha job brings correct records, but when a sequencer runs the j...

Folks, this is first time i am working for production support, I did develop lot of projects, so sorry for bombadring with stupid question, here is my todays question in the constraint I find 0=1 and this is link is used to do bulk load using ORABULK, can some tell me what does this mean thanks ranga

What does this mean? does it mean Trim(inXfmDataScrub.GENDER) Is null then @True else @False?
thanks

KC, Ther is no lookup, then @False means nothing should go in right? is there some thing do with any keys The job Inputlink ------- @false -- outputlink1(all the primary key values) -------@False -- Ouputlink2(all primary keys + some values) -------@False -- Ouputlink2(all primary keys + All values)...

Hi,
I have a job which had one input link and four output link out of them 3 them have Constraint @ false and one nothing, no derivationsa no stage variables, what does this @False constraint do, any help appreciated

got the anwer, thanks, previously I was using IsNull only, but wanted to double check, thanks folks