| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is surrogatekey ? In ur project in which situation u
has used ? explain with example ? | | 4 |
| How can yoU improve session performance in aggregator
transformation? | | 6 |
| WAT IS TEXT LOAD? | Wipro | 2 |
| How to write a procedure for a date which is in three
different formats,and you want to load into datawarehouse in
any single date formate | AHM | 1 |
| 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 reusable transforamtions? | | 2 |
| How can you recognise whether or not the newly added rows in
the source r gets insert in the target ? | | 2 |
| what happens if you try to create a shortcut to a non-
shared folder?
| | 1 |
| How can you access the remote source into your session? | | 1 |
| What is parameter file? | | 1 |
| how to join the two flatfiles using the joiner t/r if there
is no matching port? | Cegedim | 2 |
| How can u work with remote database in informatica?did you
work directly by using remote connections? | | 1 |
| surrogate keys usage in Oracle and Informatica? | Oracle | 3 |
| in which situations do u go for scds ? | TCS | 2 |
| i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need | Deloitte | 2 |
| What is difference between partioning of relatonal target
and partitioning of file targets? | | 1 |
| What are the joiner caches? | | 2 |
| How to jion 2 tables, without using any condition? | Amazon | 3 |
| How to update records in Target, without using Update Strategy? | | 3 |
| How to load a relational source into file taget? | | 1 |
| |
| For more Informatica Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
