-
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 ...
-
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...
-
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
-
Load Data Parallelly
How to load the data in different targets in parallelly?Assume 3 targets are there 1st one should load first and 3rd one should load 2nd and 2nd one should load 3rd with in the same mapping?
-
Remove Mapping Duplicate Values
How to remove duplicate values in mapping?
abhiora24
- Oct 26th, 2010
If Source is Flat File then useSORTER transformation/Aggregator transformationIf Source is RDBMS then useAggregator transformation
-
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
-
Connect to Flat File Source
How to connect to flat file source which are in server system?
-
Fact table size calculation
How to calculate fact table size.........and how to find fact granularity? Please tell me answers to these 2 questions..
n.sriramk
- Nov 5th, 2010
Size= Number of expected records * E (sum of all columns data type size) bytes
divakar021
- Oct 7th, 2010
A Fact table is calculated based on "lowest level granualarity". The lowest level granualarity can be determined from the ...
-
-
Session Performance
How can we see the performance details about session run?
-
Can any one please tell me the architecture of Informatica and please tell me the flow of data in Iinformatica?
jayapraveen
- Nov 21st, 2010
architecture of informatica is as follows11. Source Systems: Like Mainframe,Oracle,People soft,DB2.2. Landing tables: These are tables act like source. Usedfor easy to access, for backup purpose, as r...
opbang
- Sep 21st, 2006
Power Center Architecture can be divided into two sub Architecture 1. Informatica Repository Architecture2. Informatica Server Architecture. Server 1 - Oracle Databa...
-
How to implement de-normalization concept in Informatica Mappings?
Anindya1281
- May 2nd, 2010
This can be done using str --> exp --> Agg --> exp --> targetsay src file:port1 port2A1 B1A1 B2A1 B3A2 B1A2 &nb...
-
Update Strategy
Explain update strategy transformation giving an example
naveenkumar2829
- Dec 9th, 2010
By default Informatica processes all rows as insert, but if you want to change it as per transormation logic then we have to use updata strategy transformation.
-
Workflow Dependancy
Where do we set the dependancy in the workflow?
-
Informatica and SAS Exit
-
Informatica High Availability
What is High Availability in Informatica?
Suman Lohith Korrapati
- Dec 20th, 2010
High availability is a PowerCenter option that eliminates a single point of failure in a domain and provides minimal service interruption in the event of failure.This is basically acheived at configur...
-
Informatica Loop Scope
How to perform a "Loop Scope / Loop condition" in an Informatica program ? Give me few examples.
-
-
What are the steps to create a mapplet in mapplet designer?
pasupula.naidu
- Dec 31st, 2010
1. Tools->mappletdesigner->create->give a name2. From tr menu->create->mapplet input3.
In, mapplet input tr create required ports4. Create required group of tr like sorter,exp5.
Drag the ports from mapplet input to the tr6. Create mapplet output t/rand finally save the mapplet in the repository -
What is the difference between power center and power mart?
1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?
pasupula.naidu
- Dec 31st, 2010
For mapping parameters create a notepad file like this way, Sysntax:------------- [foldername.WF:workflow_name.ST:session_name] $$para_name=valuefor session parameters,sysnatx:-----------[...
hundwanipankaj
- Apr 5th, 2010
Power Mart is a departmental version of Informatica for building, deploying, and managing data warehouses and data marts. Power center is used for corporate enterprise data warehouse and power mart is...
Informatica Interview Questions
Ans