-
Error handling Logic
How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target?
Umesh
- May 14th, 2012
So we create 2 variable for every field on which we have to do error logging. 1 variable will check the condition for error (i.e. check for isnull or check for datatype) and assign NULL if it does not...
prashant.baranwal
- Sep 11th, 2010
It is one of the most common concept which is being implement in alomost all DW projects. A very simple way of handing error and with their approprite messages is:Concat all the columns with a delimet...
-
Target Data Loading
How & Where will you can see data loading in targets dynamically?
sharmahariom
- Jan 18th, 2010
You can use Power Center Monitor. Once you will open property window in monitor you can see dynamic data loading there.
vens28
- Apr 28th, 2009
We can check the target recorded loaded dynamically by validating the query on target records with time period.1) We need to run the target records related query for first load with time period an...
