| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
| | 2 |
| What is data merging,data cleansing,sampling? | | 2 |
| Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me. | CSC | 6 |
| How will you display 10-15 letters from a name? (for ex:
name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam") | | 1 |
| What are the phases in SDLC? | | 3 |
| suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how | TCS | 4 |
| Transformer is a __________ stage
option1:Passive
2.Active
3.Dynamic
4.Static | Accenture | 1 |
| How to recover sessions in concurrent batches? | | 2 |
| What is a poling? | | 1 |
| Explain reference cursor? | | 1 |
| Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions | Infotech | 1 |
| How to update records in Target, without using Update Strategy? | | 3 |
| I still need further explanation about the difference
between active and passive transformation with some
examples.Thank You | | 3 |
| What is critical mapping? | | 1 |
| can we create index and drop index in exsisting table while
using infomatica | | 2 |
| in which situations do u go for starflake schema ? | TCS | 5 |
| I've an excel sheet, in which one column contains data about
the location like "City, State" and few columns contains
only "State". Now I wanna load into my target City and State
into two different columns. Pls help me out... | | 6 |
| HOw can we load the normalised data ( Vertical data) to
(Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. But,
what exactly I want is .. If we have million of records,it
is not possible using decode and search for that Particular
Id to pivot into Horizontal data... Can any one of guys
please help me in this regard..... | TCS | 2 |
| how many types transformations supported by sortedinput? | | 3 |
| What are mapping parametres and variables in informatica? | TCS | 3 |
| |
| For more Informatica Interview Questions Click Here |