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

...updates existing rows but after i run the workflow it ERROR: Target table [EXCPT_CD_STG] does not allow UPDATE Row # [0] in bad file WRITER_1_*_1> CMN_1053 : Rowdata: ( RowType=1(update) Src Rowid=1 Targ Rowid=1 DATA_EXCPT_CD (DATA_EXCPT_CD:Char.3:): "1" DATA_EXCPT_DESC...

...&TRGT_DBE.WORK.ET_awe_mkt_avt ERRLIMIT 1000 CHECKPOINT 0 TENACITY 2 SESSIONS 8 SLEEP 6 ; /* Begin Layout Section */ .Layout INPUTLAYOUT; .Field awe_mkt_id * VARCHAR( 20) ; .Field awe_mkt_tech_cat_cd...

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.