DSXchange

Hi all, we have a job that does a upsert , Job design is to join on XRF table and getting the surrogate key and then loading into oracle table. Now the input data which comes through a set of flat files is about 180 million records (around 20 gb) and the retention capacity of target table is around ...

Hi All,

The work around was replaced the DRS stage that was being used to read the data to a ODBC Connector and re-imported the metadata, had to import the metadata partially(10 at a time or so) but it worked.

Thanks

Try This

TrimF(Convert(char(0):char(9):char(10):char(13),'-', ColumnName))

Hi All, i have a DRS stage that is used for extracting data from sql server , couple of the columns are declared as nvarchar in the sql server database. i tried to define them as varchar and unicode as extended in the DRS stage but am receiving this error "[IBM(DataDirect OEM)][ODBC SQL Server ...

Hi Craig ,


It worked , issue is with the 7.5.1 Datastage Fix , i installed it it and it worked fine.


Thanks for your Support

Any Ideas Please

Hi Guys, I was trying to install Datastage Client 7.5.1 on my machine which has service pack 3 , Installation is done without errors but could not open Director and Manager , Designer and Administrator are working fine Just to give a brief of what happened I recently installed it on my laptop but th...

Hi,

Ok ,but the examples i saw today is a full 10 digit alpha numerical field
example : 05183207AD same in the source and hashed file , ididnt understand this part , any reason why this can happen

Hi, I have a job where i use a hashed file for lookup which has only two coloumns one of them is char 10 field this is the key field and the same field is coming from the source which is also a char 10 field. My problem is there are some records which it throws as reject but the data is there both i...

Hey Guys I got it solved , We have four projects and the rest of the schedules in other projects are running fine with the same cron so i checked the files and found couple of them missing from this project which are dsr_sched.sh and dssendmail_template.txt I have to investigate on why they got dele...

Hi

We just schedule our sequencers in the director, i checked the cron tab it listed the entry for the particular sequencer , when i changed the time it got reflected in the cron tab but its not able to start the sequencer

Hi We have a daily schedule which runs at 5 pm but suddenly it stoppped today, i mean its not able to start at the stipulated time , i have to manually kick off the jobs schedule . This is infact happening with all the sequencers when i tried to test different sequencer. Can anyone shed some light o...

If you are from Mainframes take the cobol copy book (i mean the metadata) ftp it to your pc and save it with .cfd extension. Then create a new table definition from cobol definitions and it automatically generates the table definitions for you. Then do a ftp of your file with binary mode ,just read ...

Guys,


Can someone tell me how to post the generated report from a job ,Actually i just want to post one here which can help ArijitS



Thanks[/url]

Check your Paramters if anything is fishy there. If u can view the data from sql plus u shoukd have tns entry, aslo see if u have select permission enabled for ur datastage id on that table