DSXchange

ok Chulett..

Hi

How to configure a condition to execute a sequence task only when there are rows in a file.

How to write a condition to execute a sequence task either when there are warning messages or when there are no warning messages in the preceding task.

Hi ,

In my requirement i will also need to log audit data. For example the file name , file size . record count in the file etc.. How can i do that ?

Could you please give some suggestions ..

Thanks in Advance..

Hi Everyone,

It worked .. Thanks a lot for sharing the knowledge..

Hi Thanks for your replys .. But my source(db2 database/odbc EE stage) has 2 million records flows to a copy stage ; from their one link directly loads in to target sql server(drs stage) and 2nd link from copy stage to aggregator where it takes record count as aggregation type and loads just 1 recor...

When i checked with the developer he has said that there is no such primary key violation (he is not inserting any duplicate records) and same job runs fine say for the first time and if i run the same job again it is throwing an error Network buffer underflow. Can any one please suggest an approach...

Hi Chulett, Gr8 the script has worked. Thanks for you suggestion. But again i got a warning ./GetFile.ksh[73]: mutt: not found. After searching the forum with the key word mutt i understand that mutt is email client on unix machine. i guess we dont have mutt installed on our sunOS 5.9. so how can i ...

Thanks for your reply chulett. I will post the result once after adding those variables. But just want to know why is it an error at line 41 with unexpected error.

Hi Everyone, Below is the script which is used to get files from FTP share site. The script is working fine on AIX environment but when i try to excute the same script on Sunos5.9 its throwing an error > sh ./GetFile.ksh SetEnv() { logDir=/export/home/vvivek PasswordCtl=/export/home/vvivek/FTPPasswo...

Hi , I have a requirement -- One of the source system will produce a file daily (.csv) and place it in a designated directory on their FTP site.I need to create a method to automatically transfer this file via FTP and place it in a local directory on my sever.( I will also need to log audit data and...

Hi Everyone, Before posting this question i have searched the forum and couldn't find the similar posts. I have a job design ,source as db2 database and target sql server. some records are getting rejected and the job log is has warning SQLFetch: Error retrieving results from server. Warning: : [IBM...

Hi The metadata in all the worksheets will be the same. The only issue is that the number of worksheets can be changed at any time by the Business user. File1 can have 3 worksheets, File 2 can have 5 worksheets. So i am looking whether this process can be automated in data stage so taht it picks up ...

Hi Ray,


Iam using user defined SQL as read method to pull data from DB2 database.In the job monitor i found that 11.34 mins of total time 12 mins is taking for the source stage. can i play by changing the array size , read committed ? What changes have to make to improve it. Please sugest.


Thanks

Hi Ray,


Iam using user defined SQL as read method to pull data from DB2 database.In the job monitor i found that 11.34 mins of total time 12 mins is taking for the source stage. can i play by changing the array size , read committed ? What changes have to make to improve it. Please sugest.


Thanks

Hi ray Thanks for ur reply. As you said the tabs got exported in the form of system tables with $. This corresponds to only the tabs in File 1. I used a user defined query to read data from tabs and write to a table. But what shall be done if there is a file2 with the three tabs. Its not possible to...