Search found 3329 matches

by Sainath.Srinivasan
Thu Jun 02, 2005 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Defining SCD Type at the record level
Replies: 8
Views: 1370

Yes. W.r.t. that one col.
by Sainath.Srinivasan
Thu Jun 02, 2005 8:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Format Problem (Urgent ) (Ray your help please)
Replies: 9
Views: 2069

You can use normal transform to check the field count to do this.

Anyhow, as you have asked for Ray's help, I will leave it to him to answer.
by Sainath.Srinivasan
Thu Jun 02, 2005 8:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to compare two dates in DS format SQL.SMALLDATETIME
Replies: 6
Views: 1442

Make sure the format is yyyy/mm/dd. Also check you have 4 digit year.
by Sainath.Srinivasan
Thu Jun 02, 2005 8:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to remove the duplicate records
Replies: 10
Views: 2294

You can do a sort with stage variable check or use agg if the data volume is low.

There are many other ways and everything depends on detailed analysis of what you are doing and what you wish to achieve.
by Sainath.Srinivasan
Thu Jun 02, 2005 4:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash/Seq file value to set as parameter
Replies: 6
Views: 1562

To keep it simple, you can create a table in your db and populate it with the value from hash-file. This will assist you in writing an SQL linking this table from hash-file and you will not need any parameter to be passed.
by Sainath.Srinivasan
Thu Jun 02, 2005 4:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to write a routine
Replies: 3
Views: 872

You can sort the source to appear in order of history and use stage variables to achieve your desired result.

As your requirement appears to be incomplete at this moment, you can better decide the logic you wish to follow with the skeleton method mentioned above.
by Sainath.Srinivasan
Wed Jun 01, 2005 2:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting warning message in viewing data in source
Replies: 7
Views: 2178

Check the number of columns in your source file. Maybe your source file did not change to 49 cols.
by Sainath.Srinivasan
Wed Jun 01, 2005 2:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: out of space on server
Replies: 3
Views: 1014

Did the installation ran out of space of was it the project due to jobs.

If it is the project, then take an export, recreate it in the next place and import.
by Sainath.Srinivasan
Wed Jun 01, 2005 2:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash/Seq file value to set as parameter
Replies: 6
Views: 1562

You need to create a stand-alone job that reads the value from the hash-file and returns as the status. The next job can then obtain this value and include this as a parameter in the SQL.
by Sainath.Srinivasan
Wed Jun 01, 2005 2:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: German Character in the files
Replies: 11
Views: 4265

What error message you are receiving?

Did you check whether the link is NLS enabled?
by Sainath.Srinivasan
Wed Jun 01, 2005 2:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to handle EBCDIC Data files
Replies: 2
Views: 601

The access violation implies permission issue with the stage. You need to provide more info on what you are doing and what error message and at what stage.
by Sainath.Srinivasan
Wed Jun 01, 2005 9:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting warning message in viewing data in source
Replies: 7
Views: 2178

You will need to include the 2 columns in your column defn tab.
by Sainath.Srinivasan
Wed Jun 01, 2005 3:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delta load methodology
Replies: 5
Views: 1758

And also include an upper cap for the extract period so to know where to start next time.
by Sainath.Srinivasan
Wed Jun 01, 2005 2:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Settings for Sending Mails
Replies: 8
Views: 5918

Check the SMTP server name supplied as part of the notification stage.
by Sainath.Srinivasan
Tue May 31, 2005 11:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reading variable length data
Replies: 12
Views: 3680

You can build your custom operator to do it.