| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is query panel? | | 1 |
| What are the basic needs to join two sources in a source
qualifier? | | 3 |
| What are the new features in Informatica 5.0? | | 1 |
| what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
| | 1 |
| how to load only the first and last record of a flat file
into the target? | CTS | 4 |
| How the informatica server sorts the string values in Rank
transformation? | | 1 |
| What is factless fact schema? | | 1 |
| 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 | 3 |
| how to load duplicate row in a target | | 2 |
| what is difference between COM & DCOM? | Satyam | 1 |
| What are partitions in informatica and which one is used
for better performance? | | 1 |
| What are the Advantages of de normalized data? | | 2 |
| How to improve the performance of Aggregate
transformation? | Dmss | 2 |
| how to obtain performance data for individual
transformations. | | 2 |
| What is critical mapping? | | 1 |
| What are the types of groups in Router transformation? | | 1 |
| daily how much amount of data send to production? | HSBC | 1 |
| Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you
| | 4 |
| What is surrogate key? | | 4 |
| How to extract original records at one target & Duplicate
records at one target? | | 5 |
| |
| For more Informatica Interview Questions Click Here |
Site Map
