Answer Posted / bebo
a confirmed dimension is a dimension which is used in more
then one datamart...exp time dim or customer dim
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How can we delete duplicate rows from flat files?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Have you worked with/created Parameter file
What are the data movement modes in informatica?
how many types of dimensions are available in informatica?
What are the components of the workflow manager?
What is the meaning of decode in informatica?
Define sessions in informatica etl?
Tell me about MD5 functions in informatica
Does an informatica transformation support only aggregate expressions?
How do we call shell scripts from informatica?
How to extract sap data using informatica? What is abap? What are idocs?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to do unit testing in informatica?