| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| In mapping f.f as one src and f.f as trg,f.f as src and
oracle as trg which is fast? mean which is complete first
process | Wipro | 2 |
| What is DTM process? | | 3 |
| Had any one faced informatica(ETL/Developer),
Datawarehouseing interview in UK.
Than plz help me (i have any exprience of 3yrs
informatica,datawarehousing,oracle,teradata)
1.hw the procedure will b here
2. wht type of question's they will b asking.
3.In which area they concertate more.
since this is the first time im facing interview in UK.
plz help ASAP.it will b a great help for me
thanks to All in Advance | | 2 |
| Explain reference cursor? | | 1 |
| What happens if you increase commit intervals and also
decrease commitExplain grouped cross tab? | | 2 |
| Which kind of index is preferred in DWH? | | 2 |
| what is a time dimension? give an example? | | 2 |
| Which is costliest transformation? costly means occupying
more memory? | | 1 |
| how to run the batch using pmcmd command | Wipro | 1 |
| how to duplicates from expression transformation without
using sorter before that | | 1 |
| Which tool yoU use to create and manage sessions and batches
and to monitor and stop the informaticaserver? | | 3 |
| what are the different types of transformation available in
informatica and what are the mostly used ?
| | 3 |
| What is the difference between Power Centre and Power Mart? | TCS | 3 |
| how can u connect client to ur informatica sever iff server
is located at different place( not local to the client) | Accenture | 2 |
| sir presently i am persuing my m.tech
recently i got job in tcs as fresher presently iam doing my
9 months project related to informatica can any one guide
me how to create fact tables what type of schemas must be
used and so on if so give ur mail ids so that i can contct
through it | | 1 |
| What is Code Page Compatibility?
| | 1 |
| can v update d records in target using update stargey
without generationg primary key ? explain | CTS | 3 |
| IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ? | HP | 4 |
| What is Factless fact table ??? | Tech-Mahindra | 7 |
| Explain the flow of data in Iinformatica? | | 1 |
| |
| For more Informatica Interview Questions Click Here |