Search found 71 matches
- Tue Oct 19, 2010 2:26 am
- Forum: General
- Topic: AFTER/BEFORE ROUTINE
- Replies: 1
- Views: 2410
Job level routines are executed as per their definations i.e. before job subroutine executes before job execution ..e.g. In most of the cases it is used to create the input files or move or copy the files .. After job subroutine executes after the job's successful completion. E.g. mostly to remove t...
- Tue Oct 19, 2010 1:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Records skipped when reading sequential file
- Replies: 5
- Views: 3232
Hi Check the first column values in all three records R00450000010100|ONE|ACTIVE|90286|DIRECT|2010-01-10|2011-01-10 R004P0000010100|ONE|ACTIVE|90286|DIRECT|2008-05-20|2011-01-10 R004000010100|ONE|ACTIVE|90286|DIRECT|2007-03-10|2011-01-10 You need to check the first column metadata, it seems that met...
- Mon Oct 18, 2010 7:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CombinedOperatorController(6)
- Replies: 6
- Views: 6417
May be something that worth checking :- 1. Whether connectivity is working fine or not ! You can select some other table and check for the connectivity and giving the results as expected.. 2. You can enable the APT_DUMP_SCORE true, to get the detailed logs so that you can Trace the data. 3. You can ...
- Mon Oct 18, 2010 6:57 am
- Forum: General
- Topic: Link Naming Standard
- Replies: 11
- Views: 7860
There is no standard as such, however the name should reflect what exactly the purpose of that link.. Suppose you are reading from any database stage Link name could be :- L_TableName L_TableName For Sort Stage L_DataSort It also depends on your projects, however these linknames should be consistent...
- Mon Oct 18, 2010 6:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how remove duplicate in transformer
- Replies: 7
- Views: 4646
You can use the following logic to remove duplicates using the Transformer Stage, however for that you need to have data sorted. Before using the transformer Stage, use Sort Stage to sort the data. In Transformer Stage, take the FirstRecordVar=SecondRecordVar IncomingLnk.Value=FirstRecordVar Then in...
- Mon Sep 27, 2010 5:18 am
- Forum: General
- Topic: Job search in unix
- Replies: 8
- Views: 5797
Before running query you have to check for UV command. You need to setup the datastage enviormental variable. And if there are multiple projects, you have to logon on those projects and then you can check the job specific properties as well.. One UV is set, you can query datastage tables to get the ...
- Mon Sep 27, 2010 4:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Is there any relation b/w dataset, configuration file
- Replies: 7
- Views: 4255
Hi, Is there any relation b/w dataset, configuration file or seq file and configuration file As I am not the premimum member I was not able to view the latest post..( may be repetative info ! :D ) Dataset is persistent stoarage for datastage which is stored depending on how many nodes used in Config...
- Wed Jun 23, 2010 5:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Load Error
- Replies: 11
- Views: 9704
Hi Is this first job you have designed which is writing to the database. If not, can you check the database related parameters from the previously designed jobs and check if you are passing any incorrect value.. If this is first job, then it seems that the there is issue with the database connection...
- Tue Jun 08, 2010 3:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to specify lookup found condition in EE ?
- Replies: 10
- Views: 4462
I mentioned 0 and it worked. Now I have my constraints as follows: If Column_From_Lookup = 0 then Insert Else Update and then I am passing only Inserts to Target. I am facing a different problem though...when we have both Insert and update coming in the same load even though I mentioned Array size ...
- Tue Jun 08, 2010 3:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help in Range lookup
- Replies: 7
- Views: 3542
Hi
Do have a look at the following link which will help you to get into more datails about the range lookup..It is also having some examples attached with this which can help you sort out your issues..
http://it.toolbox.com/blogs/infosphere/ ... kups-16911
Do have a look at the following link which will help you to get into more datails about the range lookup..It is also having some examples attached with this which can help you sort out your issues..
http://it.toolbox.com/blogs/infosphere/ ... kups-16911
- Wed Dec 23, 2009 6:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Striping Line Feed Character
- Replies: 7
- Views: 6075
- Wed Dec 23, 2009 6:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-00942: table or view does not exist
- Replies: 15
- Views: 18125
You are saying that same job is working in development enviorment. Which means there are issues with the settings of your database connections in production. You can check all the database related parameter settings. As it was giving error of table is not present means datastage is not able to read ...
- Thu Mar 05, 2009 5:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SFTP error
- Replies: 5
- Views: 3232
1. Check your datastage director logs carefully. The parameters which are used. Does it give any other messages. 2. Check number of records in the input file, whether the director says that number of records are imported successfully ? 3. Check the location in the remote server. There may be case th...
- Thu Mar 05, 2009 4:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Running very slowly
- Replies: 4
- Views: 2846
You can take a look at the following link http://www.ibm.com/developerworks/data/library/techarticle/0301kline/0301kline.html It explains how exactly the circular and archival logging works. If you are saying the data volumes are same, datastage jobs are same it must be the database related issue. I...
- Wed Mar 04, 2009 8:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unable to View data using a ODBC stage
- Replies: 6
- Views: 5130
You can try out following things ! 1. When you fire your query on database, whether it works fine.Check the cost of the query. 2. Is there any other job using ODBC stage in your project.Check what are the properties set for that particular stage.There might be some property which you have set incorr...