| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to run two workflow(not a sessions) sequentially, what
is the process. Plz explain detailed information. | Keane-India-Ltd | 3 |
| which T/r we can use it mapping parmeter and mapping
variable? and which one is reusable for any mapping mapping
parmeter or mapping varibale? | Wipro | 2 |
| how to declare array in plsql? | | 1 |
| what is metadata? | | 5 |
| how to load duplicate row in a target | | 2 |
| what is update strategy transformation ? | | 3 |
| what is casual dimension? | IBM | 3 |
| What is the actual work done in Development and in the
production depts in building a datawarehouse.
Which dept is more interesting and career oriented . | | 1 |
| What are the methods for creating reusable transforamtions? | | 2 |
| what is a transforamation? | | 3 |
| What are the circumstances that infromatica server results
an unreciverable session? | | 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 | 1 |
| What is the default join that source qualifier provides? | | 1 |
| Why touse stored procedure in ETL Application?
| | 1 |
| i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow | Wipro | 4 |
| what is mean by grouping of condition column in lookup
transformation? | | 1 |
| What is Factless fact table ??? | | 6 |
| WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ? | Target | 6 |
| How to delete duplicate record in Informatica? | | 3 |
| What are the challenges of Dataware housing in the future? | HP | 1 |
| |
| For more Informatica Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
