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 are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
What is the status code in stored procedure transformation?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
If you want to create indexes after the load process which transformation you choose?
need for registering a repository server
What is a filter transformation and why it is an active one?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
Please let me know how to make encryption and decryption with example?
Explain informatica architecture - version 8 / 9
What is difference between partioning of relatonal target and partitioning of file targets?