| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the types of maping in Getting Started Wizard?
| | 1 |
| What is an MDDB? What is the difference between MDDBs and
RDBMSs? | | 2 |
| Define informatica repository? | Wipro | 1 |
| How many repositories can we create in Informatica? | | 2 |
| I have Employee table, 10 cols are connected to next
transformation, only 4 cols are selected in SQL override.
What would be passed to next col. | BirlaSoft | 4 |
| After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how? | | 2 |
| What is the Hierarchy of DWH? | | 1 |
| What are the diffrences between joiner transformation and
source qualifier transformation? | | 2 |
| What is the difference between Normal load and Bulk load? | | 2 |
| Hi i am new to Informatica. I have few question's in
Informatica. Can any one respond, it will be appricaited.
Q.Is Flat File Contains the Dynamic Cache? | | 4 |
| Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me. | CSC | 6 |
| Had any one faced informatica(ETL/Developer),
Datawarehouseing interview in UK.
Than plz help me (i have any exprience of 3yrs
informatica,datawarehousing,oracle,teradata)
1.hw the procedure will b here
2. wht type of question's they will b asking.
3.In which area they concertate more.
since this is the first time im facing interview in UK.
plz help ASAP.it will b a great help for me
thanks to All in Advance | | 2 |
| Can you start a session inside a batch individually? | | 1 |
| Without using any transformations how u can load the data into
target? | IBM | 10 |
| 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 |
| from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic | Deloitte | 11 |
| what happens when a batch fails? | | 3 |
| What is a unit Testing? | | 1 |
| What is Datadriven? | | 2 |
| When the informatica server marks that a batch is failed? | | 2 |
| |
| For more Informatica Interview Questions Click Here |
Site Map
