| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 to recover the standalone session? | | 2 |
| what is the flow? | | 1 |
| How will you display "Mr" for male & "Mrs" for female in
target table? | | 4 |
| what is the architecture of any Data warehousing project? | IBM | 4 |
| How to call stored Procedure from Workflow monitor in
Informatica 7.1 version? | Accenture | 1 |
| what is the gap analysis? | | 1 |
| How to load time dimension? | Ford | 1 |
| what are the transformations that are used in data
cleansing ? and how data cleansing takes place ? | | 2 |
| What are the active and passive transforamtions? | | 2 |
| What are differences between Informatica 7.1 and 6.1 | | 3 |
| Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches? | | 3 |
| What are partitions in informatica and which one is used
for better performance? | | 2 |
| How do we come to know the Source data/file is
ready/Updated in the source location, when the session is
scheduled for @12:00AM and ready to run its job ? or Can we
schedule the session, when the source is updated in source
location without any time constraint? | iFlex | 2 |
| what is diff between grep and find | iFlex | 1 |
| In update strategy target table or flat file which gives
more performance ? why?
| | 1 |
| scd methodology? | | 2 |
| Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions | Infotech | 1 |
| 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 |
| What are the different threads in DTM process? | | 1 |
| |
| For more Informatica Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
