error handeling in informatca power center

Posted by user223541 on Stack Overflow See other posts from Stack Overflow or by user223541
Published on 2009-12-14T13:41:20Z Indexed on 2010/05/18 2:40 UTC
Read the original article Hit count: 290

Filed under:

powercenter

|

informatica

|

data-warehouse

i want to devlop a mapping for followinfg scenerio . I have a 1 source and 1 target and 1 error table.Target and Error tables have all fields that are present in source tables.But the data type o of all fieds for error table are varchar .Error table dont have integirty or foreign key and other constraints . Error table also have2 more fileds .Error no and error msg. Now when the workflow is executed if there is erro while inserting any record then that recored shold be moved to error table.Also the data base error code and error message should be logged in error no and error message in error tables fields as mentioned. How can i devlop such a mappng?Where can i find exaples of such mapping ?

© Stack Overflow or respective owner

Related posts about powercenter

How do I restore the layout on Expression Editor in Powercenter

as seen on Server Fault - Search for 'Server Fault'
I am using Powercenter 8 and I am not sure how I did it, but I have messed up the Expression Editor Layout, so now I am unable to see the expression that I am building. Does anyone know how to restore the screen back to its normal layout. Thank you >>> More
informatica mapping examples

as seen on Stack Overflow - Search for 'Stack Overflow'
i want to devlope generic mapping for handling data bases errors in Informatica. Can any one give me any examples of such mappings ? Also can u suggent me some resources for informatica samples mappings (livw webiste or links) >>> More
error handeling in informatca power center

as seen on Stack Overflow - Search for 'Stack Overflow'
i want to devlop a mapping for followinfg scenerio . I have a 1 source and 1 target and 1 error table.Target and Error tables have all fields that are present in source tables.But the data type o of all fieds for error table are varchar .Error table dont have integirty or foreign key and other constraints… >>> More
Error while accessing the Informatica web service methods

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am facing the error "This represents an internal error at the Informatica PowerCenter Web Services Hub. error code is : WSH_95000" while access the informatica web services methods.I am able to login and able to get the sessionid provided by the login response. I am passing the same session… >>> More

Related posts about informatica

error in installing informatica.

as seen on Stack Overflow - Search for 'Stack Overflow'
"The installer cannot ping the domain.Verify that Informatica Services is running on the domain host and select Retry. STDOUT: [1212] Command [ping] failed with error [[2121] Node [raskart] Domain [Doraskart] Host:Port [Doraskart:6001] has failed to ping back.]. exitcode -1 " This error occured… >>> More
Error while accessing the Informatica web service methods

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am facing the error "This represents an internal error at the Informatica PowerCenter Web Services Hub. error code is : WSH_95000" while access the informatica web services methods.I am able to login and able to get the sessionid provided by the login response. I am passing the same session… >>> More
joining null in MS SQL server, Oracle and informatica

as seen on Stack Overflow - Search for 'Stack Overflow'
hi! I've two tables to join with a column(say emp_id)..if emp_id in both the tables have null values, how'll MS SQL server and Oracle treat??? Coz, i read that informatica will neglect the NULL rows when joining..if i handle the null, by substituting -1, a cross-join will happen which i don't want… >>> More
I need information about Informatica

as seen on Stack Overflow - Search for 'Stack Overflow'
I need some information about the Informatica ETL tool. I am a rookie with that, so could you please recommend where can I get some tutorials to get started. Can I download the tool, and if so where can I download it? What are the alternatives to Informatica? >>> More
Cloud INaaS from Data Integration companies

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Traditional integration IT vendors are also starting to offer INaaS. Infomatica has been the most aggressive integration vendor when it comes to offering INaaS. Informatica has offered INaaS for over five years and continues to add capabilities, has a number of high profile references, and also… >>> More