what are the transformations that restricts the partitioning
of sessions?
Answer Posted / swetha
Advanced External procedure tranformation and External
procedure transformation: This transformation contains a
check box on the properties tab to allow partitioning.
Aggregator Transformation: If you use sorted ports you can
not parttion the assosiated source
Joiner Transformation : yoU can not partition the master
source for a joiner transformation
Normalizer Transformation
XML targets.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
In development project what is the process to follow for an etl developer from day1
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
waht type of interface is used for testing the data in informatica
Enlist the differences between database and data warehouse.
What is informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain sessions. Explain how batches are used to combine executions?
Why do we need informatica?
what is size of u r database?
How to go to the older version for a mapping?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What differs when we choose the sorted input for aggregator transformation?
What is the use of transformation?
What is xml source qualifier transformation in informatica?