DSXchange

Thanks Chuck for the quick response. I should have asked it with my initial question. I have one related question to this. Please let me know if I should be posting this separately. The Scenario is: I have 5 flat files(f1,f2,f3,f4,f5). These files are FTPed daily to an assigned folders on unix. 5 jo...

Hi, I have a Master job in a sequence(that does some inserts in a table). After succesfull completion it in turn starts the 5 other jobs simultaneuosly. There is one more job that has to be run ONLY after the sucessfull completion of all the five jobs. Is it possible to start the last job after the ...

Thanks Ray, Craig and Srikant...for providing the info. This really helped. Also, wanted to share....I found something today to do this in Unix using awk utility: awk -F'|' '{if(length($3==3)f="outfile1;else f="outfile2;print > f}' INPUT_Source_File Its look for 3 digit number in column 3 ...

Hi All, I have a situation where I am doing the load from flat file to teradata tables using Datastage. I have more than 300,000 rows in the flat file that has about 16 columns. The flat file is pipe dilimited and is on UNIX. This flat file is created from two different source with same metadata. Th...

Hi, I have a situation, I get ONE file everyday through FTP in my unix box. That file name varies depending on the source that is sending the file to us. I have created a generic file called LOAD.TXT file. DataStage points to this file. Everyday in Unix I copy the content of the newly ftped file to ...

Hi, I am doing a load from flat file to Teradata Database. I am generating a surrogate key from the DataStage which is a Primary Key in the Table. I have created 2 jobs in the Job Sequence that runs one after the other and the trigger is OK...Conditional. It is the last Job in the job sequence, that...

Thank you all very much on providing the information. I really appreciate the help and advice and taking out time to help me resolving this issue. Thanks for the routine, it realy made my life little easy.

Thanks
Raj

Thanks for all the time and advice in this regards. It did worked. I am able to get only the numbers now. But today I came accross one more scenario like: (800) 123 - ABC2, 800-ABC-EFG1. It is alpha numeric. I need to keep the characters and numbers and not the brackets or dashes. Can you please hel...

Hi, I have situation where I have a phone column in teradata that is loaded from a flat file. The flat file data contains different format for phone numbers something like this: (123)456-4567, 123/456/4567, (123) 456 / 4567, (123) 456 - 4567, 123, 456 - 4567. Is there a function or a way to transfor...

Do we have to write a parser for the XML file in data stage or data stage can handle XML read and write all by itself. Thanks Flat file is fastest, if for no other reason than that it's easier to parse the data from it based on metadata definitions. You only need to process flat file metadata once (...

Hi, I wanted a recommendation related to a Flat File vs. XML. My company is debating on using an XML vs. flat file as a SOURCE in data stage. The data size will be around 300,000 rows. I need recommendation on pros and cons of using XML over Flat files. Is using XML is beneficial than flat file in d...

Hi, I have a situation to concatinate a hardcoded string with another. Something like below: '<ISP>':DSLink3.Table_column1:'</ISP> ':'<DI>':DSLink3.Table_column2:'</DI> I have to pass this as one string per row in a table. But the problem is: if any of the above columns in a table(Table_column1 or T...

Is there a way to encrypt the file in .pgp and the format needs to be in ASCII.

ogmios wrote:On UNIX look at "man crypt". You have to get the password to use from somewhere though.

Ogmios

Hi,

I have generated a flat file using DataStage7.x on unix. Is there a way to encrypt this flat file either using DataStage or Unix. Actually I have to FTP an encrypted file.

I will really appreciate any help on this.

Thanks
Raj

Hi,
I have a situation to load a data to Flat File from RDBMS. Can we make the flat file TAB delimited.

Thanks!