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
Search found 100 matches
- Fri Feb 08, 2008 4:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparison between Database and dataset
- Replies: 13
- Views: 4117
- Fri Feb 08, 2008 2:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparison between Database and dataset
- Replies: 13
- Views: 4117
- Fri Feb 08, 2008 1:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparison between Database and dataset
- Replies: 13
- Views: 4117
- Thu Feb 07, 2008 9:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparison between Database and dataset
- Replies: 13
- Views: 4117
Comparison between Database and dataset
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...
- Fri Jan 18, 2008 3:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting string to Timestamp
- Replies: 2
- Views: 1253
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...
- Thu Jan 17, 2008 11:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting string to Timestamp
- Replies: 2
- Views: 1253
Converting string to Timestamp
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:...
- Mon Nov 05, 2007 7:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting timestamp to GMT
- Replies: 2
- Views: 1399
- Mon Nov 05, 2007 2:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting timestamp to GMT
- Replies: 2
- Views: 1399
Converting timestamp to GMT
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,
- Thu Jul 05, 2007 6:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is it possible to acess Oracle in Unix from DS in Windows
- Replies: 4
- Views: 1240
- Fri Jun 22, 2007 2:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Key Expression
- Replies: 8
- Views: 1993
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...
- Thu Jun 21, 2007 3:45 am
- Forum: General
- Topic: Tools Evolution
- Replies: 3
- Views: 2473
Tools Evolution
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...
- Wed Jun 20, 2007 5:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Different Versions of DS in Same Domain
- Replies: 5
- Views: 1627
- Wed Jun 20, 2007 1:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Different Versions of DS in Same Domain
- Replies: 5
- Views: 1627
Different Versions of DS in Same Domain
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...
- Tue Jun 19, 2007 5:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Upgrade to DataStage 7.5 or Higher
- Replies: 2
- Views: 1200
Upgrade to DataStage 7.5 or Higher
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...
- Thu Jul 21, 2005 11:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mail
- Replies: 1
- Views: 1178
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... > ...