DSXchange

I understand that if i use the database for a lookup it creates virtual dataset.My problem is I am doing this lookup many times and almost in all the jobs.So is it good to use the database everytime?


Thanks

So I dont have to load the data in dataset and then do a lookup right?

Ray Thanks for your reply.The lookup that I use is static. and there will be max 500 records in it.But I use this many times.So in this case also 'Sparse' lookup is better than dataset right? In general, unless you explicitly specify "sparse" lookup, you will be performing your lookup agai...

Hi All, I am working in a project where is we use Datastage 7.5.2 and db2 as database.I have a senario where in I have to do a lookup on the code tables many times. I want to know is it better to use database everytime or load the table in a dataset and then do a look up on that dataset. If anyone h...

Doubt there is any AM/PM conversion by default. You can try doing it in Transformer stage. 1) Get the hours using substring function. 2) If it is AM then pass the string directly. 3) If it is PM then add 12 to the hours, concatenate it with the rest of the string and then convert it to TimeStamp. A...

Hi All, In my project we use a DB2 DB as source.and I am loading data to dataset.I have a column in one of the source table which is Varchar(50).The data looks like this: 11/01/2000 2:21:03 PM 10/26/2000 9:45:28 AM 12/27/2000 1:15:06 PM 10/26/2000 11:20:43 AM 10/26/2000 11:28:08 AM 11/01/2000 11:39:...

Its only for USA

Hello, I have a requirement where in my input is timestamp in "YYYY-MM-DD HH:NN:SS" format.This input is from the same timezone.My output should be 2001-12-17T09:30:47-05:00 with GMT offset.How will I convert timestamp to GMT? How will I take care of the day light savings? Thanks in advance,

Why is it a problem?. Make sure you install a Oracle client on your 2003 server else you have to use ODBC to connect to Oracle database.

Based on your reply,I'm assuming your lookup data is in the hashed file. You cannot change the keys in hashed file. If you have defined two columns as key columns while loading you have to use the same columns as keys while reading. Else, you will get incorrect data. Other option will be to load dat...

Hello, I want convince the client in choosing DataStage Vs Informatica. The way they want is evolution of DataStage and Informatica from their earlier versions ( in past 6-7 years). We all know how DataStage evolved rapidly in past 3-4 years adding new features,adding parallel engine and all the new...

Thank you very much for your reply

We are in process of finalising the upgrade from 5.2 to 7.5.1 and want to know if the two versions can co-exist on the same Unix server. We want to install new version and import the project from 5.2 export and have to two run parallely until we get comfortable with new version. The problem is we ha...

Hi all, One of my client is using DataStage 5.2 on Unix and wants to know the impact of upgrading to 7.5 or higher(IBM IS 8.X). My experience shows that there is no impact what so ever in upgrading to higher versions. Entire code is server jobs.I searched the forum and the message is no impact. Also...

Hi I am trying to test the mail notification and it is not able to send the mail.I am getting the following error.I have used this feature without modifying any file in later versions.Can any one help me with the issue? Test completed. DSLogWarn called from : DSSendMail Message to be logged is... > ...