Search results for query: *

Hi, I have 2 types of files..the first type of file has a prefix adhoc_data_mmx.account.service.12152004.001 and the other type of file has a prefix data_mmx.account.serivce.12092004.001 now what i want here is each of the file has a header record in it. but if the file is a zero byte it will...

Hi, I am trying to lookup on the target based on DATA_EXCPT_CD and want insert new records and update the DATA_EXCPT_DESC or DATA_EXCPT_SVRY_CD based for existing records. When i run through the debugger my mapping updates existing rows but after i run the workflow it ERROR: Target table...

Hi, I am trying to run Mload to populate data from a flat file (load ready file)using a control file to teradata i have a shell script that runs the mload when i run the script all the records go into the error table and all is see is ? marks for all the fields the data file had 58 records the...

hi, I have a flat file source with a field recd_dt of type string now i tried to convert it to date but it gives me the following error when i run my workflow. the target field to recd_dt in oracle is of date(19) type. my To_DATE function looks like to_date(recd_dt, 'YYYY-MM-DD HH24:MI:SS')...

hi, I have a field from source acct_number of type string now i want to do a lookup on a table which has the fields acct_start_num and acct_end_num and both these fields are of type string. how do i acheive the condition where acct_number >= acct_start_num set flag to 1 acct_number <=...

hi, When i try to start the Siebel Analytics Web it gives me the error "Siebel Analytics Web failed to initialize". I checked the event log it gives the error "Error loading Analytics Catalog". Would really appreciate if anybody can help me with this.

hi, I am trying to install informatica on Win2k. I tried the installation procedure from the manuals but when i try to install the informatica repository server it gives me an error. "PmRepServer should be installed as a service." I tried to re-install couple of times but still i am stuck...

Hi, I am trying to run a presession command task for my workflow the command task looks like below (the db server is SQLSERVER and i am working on the client the INF server is DEV02) isqlw -S \\DEV02 -D HPXR -U user -P password - i "C:\audit.sql" -o "C:\AuditResults.txt" when i run my...

hi, i am stuck up with this problem its really simple i am trying to use a command task to copy files from one location to other on "Windows"the command task looks like this Copy C:\batch.txt C:\DEV\batch.txt. I ran the task in the workflow manager shows succeeded but the file does not get...

can anyone tell if this is possible 1. is it possible to have an unconnected stored procedure without any input parameters. but has output parameter whats the alternative to this ?. should i just declare an dummy input variable in my stored procedure (database) just for taking input...

I have a unconnected stored procedure(for doing updates to a table) in my mapping it should be run after the session is complete. so i set its order to Post-Target load. but the problem is the stored procedure has a port RETURN_VALUE and i am not returning anything from my stored procedure. I...

I have a pre-session stored procedure that returns a value i want to assign the return value of stored procedure to a mapping or session variable such that whenever any of the mappings run they can use that session varaible with its value and populate it into the target table. would appreciate...

can we have stored procedures in informatica with just return value and no input parameters from the source. as i want to find out the maximum value of a particular column from a table and return it.

I have four sources with no relationships between them how can i join them. will a joiner work on all 4 sources or shud i use 3 joiners to achieve this. all the sources are from the same database Also I want to identify in a mapping that if a particular field is from source A then i want its...

hi, can anybody suggest me some good links for stored procedures examples. thanks

Hi , I have a table in which i want to populate the session "run time." to one of my target table fields in a mapping. I know that if i use workflows i can get the start and end time between sessions but how do i populate that data to my target fields or is there any other way.. thanks

SQL State: 23000 Native Error: 547 State: 1 Severity: 16 SQL Server Message: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_CLAIM_RECEIVED'. The conflict occurred in database 'HPXRCareKey', table 'DATEDIM', column 'DATEKEY'. SQL State: 01000 Native Error: 3621 State: 1...

I have a target table with Member_key and Month field, I want to update the other fields in the target table when both the member_key and the Month match. if there is no unique combination of member_key and month existing in the target then i want to insert a new record into it. my target table...

i take SYSDATE(datetime (19)) and transform it to to_integer(to_char(sysdate)) in and integer port and send it target table with a port UPDATE_DATE (int (4)) .. i get a value of 4 populated in the UPDATE_DATE field.. what shud be the value of SYSDATE when converted to integer of size 4. I...

hi, this is simple but i am stuck.. i am doing a dynamic lookup on my target..but for some reason null value gets inserted into the target table.. like in my source if i have IN_POS_ID is null and in the lookup i have a condition IN_POS_ID = POS_ID. I do not want to insert records where the...