DSXchange

[quote="dtjep"]Hi, I would like to know if where is a great quantity of data is kept in the repository according the quantity of data transfered by DataStage, or if it is only metadata and so a small chunck ? Thanks you for your prompt reply.[/quote] In your config file you might have spec...

Hi Ray,

But after resetting the RFC its woring fine. Is there anyother way to resolve this problem.

Thanks
Selvam

Hi Friends, I have a job in production env, which extracts from a dataset and loads in to SAP. Dataset has a some records still the job is not extracting any records and it is aborting. Error it has given is , FATAL : Parallel job reports failure (code 139) Following are the messages I got before th...

Hi Guys,

Datastage client was closed without closing the job.Hence the job got locked. Itried to release the job thro director it didnt work. CAn u guys help me how to release the job thro datastage admin using command.

Thanks in advance

Hi Friends, I have a column called Customer_name in source table which has a data like Mr*PARKIN*BRENDA. In target table we have 3 cloumns First name,middle name, & last name I need split the Mr*PARKIN*BRENDA. Mr - first name PARKIN - MIDDLE NAME BRENDA - LAST NAME . How to do that. Please help ...

[quote="DSguru2B"]Call , You mean use. Yes, by surrounding them with hashes (#). ...[/quote]

Hi DsGuru,
Thanks a lot Guru, it works fine,my problem was solved.

Hi folks,
Is it possible to call job parameters in any other stages except transformer.
Thanks in advance

Hi all, 1) In My job am using oracle -> copy->filter->modify->trg 2) Instead of copy,filter,modify i can do all these things in transformer itself like oracle->xfm->trg And my doubt is which one will increase the performence.My source has 4 million records. Thanks in advance

Hi ,
Is it possible to scheduled the job (Director) to run for each and every hour ie) Assume that job is running now after one hour it need to run again.....,(My job will finished within 1/2 an hour) Thanks in advance

Hi,
In my job sequence i have 10 jobs , while running the 5th job my system switched off suddenly , i need to restart the sequence from the 5th job (There is no error in my jobs). How to restart my job.

Hi ,
I have 5 Job sequences and am running in 5 nodes , i have scheduled the jobs to run at 9 AM exactly. what will happen , whether itexecutes sequentially or parallely. Thanks i advance

Hi, How to write a string to sequantial file using server routine(Transform fn) I tried Writeseq function But it is giving error like, expected array,variable etc... Openseq 'filepath' to fp then writeseq 'Welcome to datastage' to fp Ans=1 closeseq fp else Ans=0 closeseq fp end This is the statement...

Hi,
After compiling & executing the job, What gets generated - exe file or OSH or anythingelse and When OSH generated.

Hi,
1) How sorted i/p file increases the performence.
2) If size of the Master table and update table exceeds the RAM size, then what will happen , it leads to page fault error or not [size=12][/size]

Hi,
Is it necessary, to select the collecting partitions technique, as same as the partition techniq, example am partioning i/p file by hash partition is it possible to collect the partitions by using different techniq.