How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / rudresh
Transformation is a repositorty object,which loads the data
into target as per the busines rule.
Transformations are two types
1)Active
2)Passive
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
How do you load alternate records into different tables through mapping flow?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is informatica worklet?
How do you promote a non-reusable transformation to reusable transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What does refresh system mean, and what are its distinctive choice?
Name the different lookup cache(s)?
In informatica workflow manager, how many repositories can be created?
What are multi-group transformations?
explan ur project architecture?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
is it possible to index the data in cache of lkp transformation ?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Why update strategy and union transformations are active?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?