| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to import oracle sequence into Informatica? | Satyam | 3 |
| What are the Advantages of de normalized data? | | 2 |
| What are the different types of Type2 dimension maping? | | 1 |
| what are cost based and rule based approaches and what is
the difference?
| | 1 |
| What is the difference between view and materialised view? | | 4 |
| what is the difference between onsite & client site? | | 1 |
| Please let me know how we can implement the below scenario.
In a single mapping,more than 500 sources
(legacy,VSAM,relational) will be loading into only one
target. Whenever I retreive the data(any record) from
target, i need to find the details that the record belongs
to which source.
Thanks in advance.. | iGate | 3 |
| what is incremantal aggregation? | | 1 |
| explain different types of modeling. | | 2 |
| What is operational data source (ODS)? | | 4 |
| What are the types of maping wizards that r to be provided
in Informatica? | | 2 |
| Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions | Infotech | 1 |
| How to create a mapping ?
id date
101 2/4/2008
101 4/4/2008
102 6/4/2008
102 4/4/2008
103 4/4/2008
104 8/4/2008
O/P - shud have only one id with the min(date)
How to create a mapping for this | Deloitte | 4 |
| what is diffrence b/w joner and union transfermation | | 4 |
| What is the status code? | | 1 |
| what are the transformations that restricts the partitioning
of sessions? | | 1 |
| what is parallel querying and what r hints. | | 1 |
| In real time scenario where can we use mapping parameters
and variables? | CSC | 3 |
| How to find from a source which has 10,000 records, find the
average between 500th to 600th record? | | 3 |
| Could any one to tell Fact table Partitioning? | | 1 |
| |
| For more Informatica Interview Questions Click Here |