DSXchange

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...

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...

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 ...

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...

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...

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 ...

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...

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...

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 ...

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

If data is like the example you have given..means if the junk character is in between, trim wont work in that case.

If you can view your inputs in unix, you can replace those junk characters..

Hope this helps !

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 ...

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...

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...

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...