Answer Posted / keerthiravi
The dimension which can be shared more than 1 fact/module called a conformed dimension. Eg: Time dimension
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does refresh system mean, and what are its distinctive choice?
What is meant by a domain?
what is the size of u r source(like file or table)?
How to extract the informatica rejected data?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the reusable transformations?
Enlist the tasks for which source qualifier transformation is used.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can one identify whether mapping is correct or not without connecting session?
What is the sequence generator transformation in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
State the limitations where we cannot use joiner in the mapping pipeline?
Can you generate sequence numbers without using the sequence generator transformation?
Performance tuning( what you did in performance tuning)
Briefly describe lookup transformation?
