DSXchange

Hi ArndW
Does it depend on the number of records?
Suppose if the file has 10 million records and there is a schema error at 999999 record. will the job still abort at the 999999 record?

Thanks
Pavan

Hi All I don't have a Data Stage Instance to try this right now but can anyone please tell me what happens in the following scenario. seq file ---> Transformer---> Oracle Table. The Seq file is having some records which are pipe delimited and matching the meta data which is specified in the Schema d...

Hi
I am looking for some documentation on orchestrate(Meta data Section) to prepare for the Datastage Certification.
it would be really helpful for me if you can suggest me which datastage pdf document has this info.

Thanks
Pavan

Thanks for Pointing it out... I am more in to making my DOS Batch File work. i am literally working on the Command Prompt . Didn't execute the basic Routine as of yet to catch this error.

Thanks for pointing it out and saving me some of my debugging time :D

Thanks
Pavan

Hi all The Trick in solving this problem is in making the FTP DOS Script File at run time. i have written the following DOS script set FTPADDRESS=green.rosettamarketing.com set SITEBACKUPFILE=*.txt set FTPUSERNAME=%1% set FTPPASSWORD=%2% CLS > script.ftp USER >>script.ftp ECHO %FTPUSERNAME% >>script...

Nope it doesn't work...
Thanks
Pavan

i changes the DOS batch file to [open %1 %2 %3 cd FAC get count.txt quit] and tried executing it from command line as follows... C:\>dosscript1 servername username password C:\>open servername 'open' is not recognized as an internal or external command, operable program or batch file. C:\>username '...

Hi All i am trying to FTP a certain set of files from a file server to my Datastage Server using BASIC Script... I have a small text file(FTPFile) with the FTP commands which looks as below ---------------- open FTPServerName username password cd FAC get count.txt quit ------------------------------...

Hi
Ray is just suggesting you to capture the audit information outside the actual Job(Main Logic whatever you are doing) coz if you include the audit capturing code in the actual job it will slow your actual job . hope you got it...

Thanks
Pavan

you can do this with a combination of small basic code and a set of jobs... Step 1: Rite a small basic code to identify if the reference data table has records in it or not. Step 2 :create two jobs one with look up and one without lookup which is a straight load Step 3 : In the basic code put a if l...

Ray, Thanks for the reply. but i am waiting for an approval from my manager for Buying Premium membership. it is soo frustating that i am not able to see the answer and try this :x but as soon as i get it i will try the solution you suggested... For a moment i thought i wont get a solution for this ...

Hi Ray The File Server is also windows and i have access to the windows file server from my datastage windows server. I can ping that file server from my datastage instance and i can access the directory and the file folder in which files are kept. Sorry if i am a bit cryptic i didn't get what you m...

Hi All
I need to achieve the same functionality on another data stage Instance which is a Server Canvass and ported on Windows Environment.
Any Ideas on how to do this....

Thanks
Pavan

Hi all is it possible to code in Data stage basic to open a table and use a select statement to read the values with where clause and assign the read values from the table as paramters to the subsequent Jobs in the basic code. I couldn't find any DS statements in helping me do this. one way i am thi...

Hi All
Thanks a lot for all your replies....