what r the transformations that r not involved in mapplet?
Answers were Sorted based on User's Feedback
Answer / santosh
*You cannot include the following objects in a mapplet:
1.Normalizer transformations
2.COBOL sources
3.XML Source Qualifier transformations
4.XML sources
5.Target definitions
6.Other mapplets
7.Pre- and post- session stored procedures
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / mythili
No the above is incorrect we can use sequence generator in
mapplet
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sivaram.k
You cannot include the following objects in a mapplet:
- Normalizer transformations
- Cobol sources
- XML Source Qualifier transformations
- XML sources
- Target definitions
- Pre- and post- session stored procedures
- Other mapplets
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / narayana
1.Normalizer
2. XML Source Qualifier
3.Target Definitions
4.Mapplet with in a Mapplet
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / rambabu7143
we can use sequence generator in the mapplet but it doesnt
make sence, because if it is in mapplet it will be reusable,
so it wont give swquence numbers properly
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / d
- Normalizer transformations
- Cobol sources
- XML Source Qualifier transformations
- XML sources
- Target definitions
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / guest
1.Normaliaer
2.xml source qualifier
3.target definions
4.sequence generator
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / vidya
1.Cobol source definition
2.Joiner transformation
3.Normalizer transformation
4.Sequence generator transformation
5.Pre or Post session stored procedures
6.Target definitions
7.XML source definitions
| Is This Answer Correct ? | 4 Yes | 7 No |
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the difference between warehouse key and surrogate key?
what type of transformation is not supported by mapplets?
How can you define a transformation? What are different types of transformations in Informatica?
Can we create two repositories on same database instance in oracle?
how to we create datamart?
How to handle changing source file counts in a mapping?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to load a relational source into file taget?
What is critical mapping?
what is the incremental agrrigation?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?