Recent content by jlito

Hi Blom, Have you already tried loading to AS400? If you have, did you have any problems on the performance? Even if there is a difference in the CPU and server configuration, the result is almost the same in terms of the throughput. Maybe the problem here is the AS400 configuration. Can...

hi Blom, I have tested it also using the update strategy. The throughput in AS400 is only 100 to 300. There is no significant change on the performance using the update strategy in AS400. Is there any performance gain when we use update strategy rather than update else insert load...

Hi Blom, The commit defined is the default value (10000) in AS400. The same value i'm using in my Oracle tables. Do I need to adjust anything? Also we are doing update else insert strategy for some of the tables in AS400. Thanks, jlito

Hi guys, I want to include a header and trailer records when writing to a flat file. The header contains an indicator "H" and also contains the business day. The same for trailer "T" and total count of the detail records. Do you have any idea on the easiest way to write a...

Hi Blom, How about the performance? If I want to return only one column from the lookup? Which lookup will return the value faster? Rgds, jlito

Now i can start my design. thanks man. rgds, jlito

Thanks. But what do you mean by passing to a lookup. I have a problem on doing a lookup on the 60 columns of the record (I'm comparing these 60 columns with a specified date in Table A). I need to know which date in the 60 columns should i take. Do you have any suggestion for this kind of...

Hi guys, I have a query here that returns 2 rows in oracle. But when i run it in informatica ver 6.1, its returning me with 3 records which is shown below. READER_1_1_1> RR_4029 SQ Instance [SQ_TGDW_GTFEXPMAS] User specified SQL Query [SELECT TGDW_GTFEXPMAS.EXPM_TXN_CCY_CD...

Hello guys, I need some help or information for this logic. I have one table (say Table A1) that has 60 columns containing date field. I have a driver table that has also a date (Table B1) Now I need to get the minimum of the date in Table A which is greater than the date in Table B. The...

Hi guys, I need some information from you. I am running Informatica ver 6.1 with different database. 1st stage (Oracle 9) oracle to oracle 2nd stage (AS400 db2 using IBM DB2 connect) oracle to AS400 In my environment right now, when I'm running any mappings using the 1st stage it is quiet...

Hi, Want to try with a simple mapping first. Then add one table at a time. You will see what is causing the problem. For my case I'm using Informatica ver 6 with 2 different database and is workfing fine. rgds, jlito

Hi, I think you are already running debugger in your machine. It can't have multiple sessions. Rgds

Hi, Just try to turn the tracing level to verbose data. Maybe you can find some useful information. Cheers!

Just think of this as a temporary table where you can do all the transformations. The advantage of this is when the target are online table we cannot update it on the fly, so one option is to put first in the staging tables and then after the you have successfully loaded it, you can now push all...

Hi, It is just another table that is join by certain key column in the source qualifier. The use of the lookup is to know whether the value is existing to another table that you want to populate in your target table. Hope this helps! rgds, jlito