-
Error Handling
How will you perform error handling in Informatica? What do you do with the bad files etc?
shr_4
- Oct 27th, 2010
Go to session log file and see no. of affected rows, applied rows and rejected rows. According to that you can know if any error occured. If any error occurs you can check why it occured and correct it accordingly.
Rajan Raorane
- Oct 21st, 2010
Use of Router Transformation and differentiate the bad file from the Required ones..hence further you can post the same in One Table
-
Star Schema
One fact table is surrounded by only one dimension table. Is it star schema or not? Give any real time example?
Rajan Raorane
- Oct 21st, 2010
Fact table surronded by Dimension table in which Dimension table must have primary key and fact table must include foriegn key
srikanthsanga
- Sep 23rd, 2010
Star schema doesn't mean that it has to be surrounded with dimension tables it depends on whether the dimension table have any more relation table to it if it has then it becomes a snow flake schema otherwise its considered as star schema
-
Can we create duplicate rows in star schema?
Rajan Raorane
- Oct 21st, 2010
No as Star Schema Includes combination Dimension table and fact table in which we already defined the Primary and foriegn key....Hence No ques of Duplicate Rows.
Ashwani
- Oct 25th, 2006
Duplicate row has nothing to do with StarSchema. StarSchema is mathodoly and Duplicate row is part of actual implementation in DB. If u look at Surrogate key conceot then "NO" beside surrogate key oth...
-
hi everyone,can anyone explain error handling in informatica with examples so that it will be easy to explain the same in the interview.
Rajan Raorane
- Oct 21st, 2010
Scenario in which when a load of 1000 records is loaded into the target and 100 records are bad records, those hundred goes to badfile dir which mention Session and the rest of the 900 should load to ...
sreenivasareddy.aug10
- Jul 10th, 2009
Error HandlingSometimes a stored procedure returns a database error, such as “divide by zero” or “no more rows”. The final result of a database error during a stored procedure ...
