| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| While importing the relational source defintion from
database,what are the meta data of source U import? | | 1 |
| What are the active and passive transforamtions? | | 2 |
| What are the types of lookup caches? | IBM | 4 |
| What is the difference between Power Centre and Power Mart? | TCS | 3 |
| There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??
| TCS | 5 |
| Discuss the advantages & Disadvantages of star & snowflake
schema? | | 2 |
| What is the difference between procedure and stored procedur? | IBM | 2 |
| How can you recognise whether or not the newly added rows in
the source r gets insert in the target ? | | 2 |
| difference between shortcut and reusable transformation? | | 2 |
| i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task
| TCS | 10 |
| what are presession,postsession success and postsession
failure commands ? | | 1 |
| what transformations are used for Variable port?
| | 1 |
| If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001? | TCS | 4 |
| What are the tasks that source qualifier performs? | | 1 |
| what is mapping optimization? wat are the techniques for tat | | 2 |
| HOW DO YOU PARFORM INCREMENTAL LAOD ? | SAIC | 4 |
| What is the difference between a table and the materialized
view? | | 1 |
| What are the unsupported repository objects for a mapplet? | | 1 |
| In a sequential batch can u run the session if previous
session fails? | | 2 |
| Can you copy the session to a different folder or repository? | | 1 |
| |
| For more Informatica Interview Questions Click Here |