Interested to Buy Any Domain ? << Click Here >> for more details...
How the informatica server increases the session performance
through partitioning the source?
- 1 Answers
- 8927 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
For a relational sources informatica server creates multiple
connections for each parttion of a single source and
extracts seperate range of data for each connection.
Informatica server reads multiple partitions of a single
source concurently. Similarly for loading also informatica
server creates multiple connections to the target and loads
partitions of data concurently.
For XML and file sources,informatica server reads multiple
files concurently. For loading the data informatica server
creates a seperate file for each partition(of a source
file).U can choose to merge the targets.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to use pmcmd utility command?
What are the components of workflow manager?
What is sq transformation?
What are the performance considerations when working with aggregator transformation?
What is the surrogate key?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What do you mean by channel change?
Write the prerequisite tasks to achieve the session partition?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the types of lookup transformation?
Slowly changing dimensions, types and where will you use them
What are data-driven sessions?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can repository reports be accessed without sql or other transformations?
What is the difference between informatica 7.0 and 8.0?
