Search results for query: *

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

Hi, Anyone of you guys who knows how to use the pmcmd command using Control-M? The thing is I want to run the different session(s)/workflow(s) using the pmcmd command built in Control-M. Thanks in advance, Jlito