what are the transformations that restricts the partitioning
of sessions?
Answer / 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 |
what is procedure to use mapping variable in source qualifier transformation? with example
How do you take care of security using a repository manager
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
Enlist the differences between database and data warehouse.
expain about the tune parameters?
what is parallel querying and what r hints.
When will you use SQL override in a lookup transformation?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
Explain about the concept of mapping parameters and variables ?
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?