| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How can u stop a batch? | | 1 |
| Can you copy the batches? | | 1 |
| What are mapping parametres and variables in informatica? | TCS | 3 |
| Why you use repository connectivity? | | 2 |
| Plz can anybody send Informatica and Cognos FAQ
Plz To thid ID ppradeep_dwh@yahoo.co.in
| | 1 |
| What are the basic needs to join two sources in a source
qualifier? | | 3 |
| I have a condition sal=100 and I created one router and in
that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100,
first which condition will satisfy, and Why? | | 8 |
| what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
| | 1 |
| How to load relational source into file target? | IBM | 2 |
| What is the term PIPELINE in informatica ? | Deloitte | 2 |
| HOW DO YOU CONNECT TO REMOTE SERVER ? | | 1 |
| What is aggregate cache in aggregator transforamtion?
| | 2 |
| Hi,
If any hav Informatica n DWH FAQ's,Plz do fwd to
vanibv6@gmail.com
Thnx
Vani
| | 1 |
| How to extract original records at one target & Duplicate
records at one target? | | 5 |
| What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use? | TCS | 6 |
| two types of data are there . one is mainframe and the other
is ascii format . in informatica how can you get both the
data in a single format in ascii . | TCS | 2 |
| 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 happens if you increase commit intervals and also
decrease commitExplain grouped cross tab? | | 2 |
| How many repositories can we create in Informatica? | | 2 |
| What are the designer tools for creating tranformations? | | 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
