What are the designer tools for creating tranformations?
Answer / swetha
Mapping designer
Tansformation developer
Mapplet designer
Is This Answer Correct ? | 4 Yes | 0 No |
can we generate reports in informatica ? How?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
why sequence generator should not directly connected to joiner transformation ?
What are the different types of Type2 dimension maping?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What are the tuning techniques you applied during your last project
What is confirmed dimension and fact?
What is a stored procedure transformation?