| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Hi Every One When i Start the Workflow, Table is Going to be
Stored in the target database But the columns are not going
to the target database table in my PC , please give me the
solution and waiting for solution | | 2 |
| 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 differences between Informatica 7.1 and 6.1 | | 3 |
| What is batch and describe about types of batches? | | 1 |
| explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ??? | CTS | 5 |
| How to recover sessions in concurrent batches? | | 2 |
| need for registering a repository server | | 1 |
| why cant we put a sequence generator or upd strategy
transformation before joiner transformation? | Satyam | 1 |
| How can the following be achieved in 1 single Informatica
Mapping.
* If the Header table record has error value(NULL) then
those records and the corresponding child records in the
SUBHEAD and DETAIL tables should also not be loaded into
the target(TARGET1,TARGET 2 or TARGET3).
* If the HEADER table record is valid, but the SUBHEAD or
DETAIL table record has an error value (NULL) then the no
data should be loaded into the target TARGET1,TARGET 2 or
TARGET3.
* If the HEADER table record is valid and the SUBHEAD or
DETAIL table record also has valid records only then the
data should be loaded into the target TARGET1,TARGET 2 and
TARGET3.
===================================================
HEADER
COL1 COL2 COL3 COL5 COL6
1 ABC NULL NULL CITY1
2 XYZ 456 TUBE CITY2
3 GTD 564 PIN CITY3
SUBHEAD
COL1 COL2 COL3 COL5 COL6
1 1001 VAL3 748 543
1 1002 VAL4 33 22
1 1003 VAL6 23 11
2 2001 AAP1 334 443
2 2002 AAP2 44 22
3 3001 RAD2 NULL 33
3 3002 RAD3 NULL 234
3 3003 RAD4 83 31
DETAIL
COL1 COL2 COL3 COL5 COL6
1 D001 TXX2 748 543
1 D002 TXX3 33 22
1 D003 TXX4 23 11
2 D001 PXX2 56 224
2 D002 PXX3 666 332
========================================================
TARGET1
2 XYZ 456 TUBE CITY2
TARGET2
2 2001 AAP1 334 443
2 2002 AAP2 44 22
TARGET3
2 D001 PXX2 56 224
2 D002 PXX3 666 332
| IBM | 3 |
| How Union Transformation is an Active Trans? | | 4 |
| To achieve the session partition what r the necessary tasks
u have to do? | | 1 |
| What is power center repository? | | 1 |
| What is data merging, data cleansing and sampling? | Satyam | 4 |
| How to call stored Procedure from Workflow monitor in
Informatica 7.1 version? | Accenture | 1 |
| what is data driven? | Wipro | 4 |
| What is Code Page Compatibility?
| | 1 |
| Please let me know how to do estimation before staring
development in project. Here estimation in the sense how
many associates are required, etc to complete the project. | iGate | 1 |
| what is a junk dimension ? | TCS | 5 |
| How to recover sessions in concurrent batches? | | 1 |
| What is aggregate cache in aggregator transforamtion?
| | 4 |
| |
| For more Informatica Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
