Search results for query: *

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

Hi, Do you have any filter condition while inserting to the target table or is it only a direct move? Have you tested your mapping by doing a fress load. Truncate all the records in your target. Do you still encounter the same problem. Please let me if it still the same. Rgds, Jlito

Hi Guys, I have created a mapping and session successfully. Then when I run the session, sometimes it returns an error that is: MAPPING> TM_6180 Deadlock retry logic will not be implemented. MAPPING> Thu May 29 09:27:04 2003 MAPPING> CMN_1038 Oracle Error CMN_1038 [SQL Stmt : SELECT...

Hi Dagon, I'm still not clear of the procedures that I need to do. Can you give me a sample script (unix and control-M)? I think we need to check on the status of the Informatica job then execute. But if not, what am I going to do next? Can Control-M check the status so it will not proceed to...

Hi sweetleaf, From which part of the work are you working if I may ask? The scheduling in DataStage is not so robust as in other ETL tools. Are you running in Unix? If yes then you can use the unix crontab command. In NT, I think you can use the NT scheduler. But the last one, I haven't done...

Hi, I need to ask a tricky question? No, it's only a simple one. I have installed the DataStage server and client in my laptop. Then I want to use the DataStage client to connect to the network (client). But unfortunately, I'm having a problem and getting this error , so I just want to verify...