| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to improve the performance of Aggregate
transformation? | Dmss | 2 |
| which quality process u can approach in ur project | CTS | 1 |
| what is plsql table? | | 1 |
| What is the procedure to load the fact table.Give in
detail? | | 1 |
| How can you access the remote source into your session? | | 1 |
| From where we can start or use pmcmd? | | 2 |
| Without using Lookup & Sequence Generator, How to generate
Sequence? | | 2 |
| how do u use sequence created in oracle in informatica?
Explain with an simple example | CTS | 2 |
|
Why is meant by direct and indirect loading options in sessions?
| | 3 |
| Can any body tell about the (UTC) unit
test cases with the examples in informatica.
| | 3 |
| What are two types of processes that informatica runs the
session? | | 2 |
| How can you complete unrcoverable sessions? | | 1 |
| What are parallel querys and query hints? | | 1 |
| if the session fails after 100 records agian we have to
starts the
session or we go for recovery session
| TCS | 2 |
| what is Partitioning ? where we can use Partition? | | 1 |
| what happens when a batch fails? | | 3 |
| If we have lookup table in workflow how do you trouble
shhot to increase performance? | | 2 |
| How to delete duplicate record in Informatica? | | 3 |
| 1)can anyone explain how to use Normalizer transformation
for the following scenario
Source table | Target Table
|
Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh
Ramesh 68 82 78 | ENG 68 73 81
Himesh 73 87 89 | MAT 82 87 79
Mahesh 81 79 64 | ART 78 89 64
|
please explain what should be
the normalizer column(s)
The GCID column
2)Also please explain the Ni-or-1 rule. | Satyam | 2 |
| How the informatica server increases the session performance
through partitioning the source? | | 1 |
| |
| For more Informatica Interview Questions Click Here |