Search results for query: *

well.. its not just one file it has 30 files where each file name is unique..i was thinking if this can be doing using some loop rather than doing it individually for each of the file...

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

the pk is DATA_EXCPT_CD. and i am using router followed by update strategy transformations but still no luck

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

in the workflow options for components i created a new command and when i click on the command editor it does not show the isqlw under drop down.. i copied the isqlw command and pasted in the command editor. should the isqlw command appear in the dropdown if so how can i do that..as i am working...

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

well i ran from the command prompt from the client system and not from the informatica server. does that mean its an issue with permissions ? but i am using the same account with which i am running my workflow.

hi, i ran it from the DOS command prompt and it works fine copy \\INFServerdev01\SrcFiles\data_1.txt \\INFServerdev01\SrcFiles\data_2.txt but when i try to do the same thing in command task in workflow it does not copy ? do i have to refer te SrcFiles by someother means in command...

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

the parameter file it shud be something like Folder.Session_name ret_val = (value returned by stored procedure) and my mapping should read the ret_val from the parameter file.

hi artiechoke, in that case how can i assign the stored procedure return value to a parameter in the file. can i just create a new parameter but how will the parameter get the value from stored procedure..?. as return value from stored procedure

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.