| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| why dimenstion tables are denormalized in nature ?
| | 1 |
| what r the values tht r passed between informatics server
and stored procedure? | | 1 |
| While importing the relational source defintion from
database,what are the meta data of source U import? | | 1 |
| star and snowflake schema? | | 5 |
| What are teh different tasks that can be created in
workflow manager? | | 1 |
| What is the target load order? | | 3 |
| What is difference between Informatica 6.2 Workflow and
Informatica Workflow 7.1 | IBM | 4 |
| What are the types of lookup caches? | IBM | 4 |
| What are the unsupported repository objects for a mapplet? | | 1 |
| Which kind of index is preferred in DWH? | | 2 |
| What is operational data source (ODS)? | | 4 |
| If you want to create indexes after the load process which
transformation you choose? | HCL | 2 |
| what are the difference between Informatica 7.1 and 8.1? | | 5 |
| 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 |
| Can you generate reports in Informatcia? | | 1 |
| What are the different types of schemas? | ITC-Infotech | 3 |
| What is a diff between joiner and lookup transformation | UHG | 9 |
| What is batch and describe about types of batches? | | 1 |
| Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table. | | 1 |
| How to enter same record twice in the target table,explain? | | 5 |
| |
| For more Informatica Interview Questions Click Here |
Site Map
