Interested to Buy Any Domain ? << Click Here >> for more details...
How the informatica server increases the session performance
through partitioning the source?
- 1 Answers
- 8908 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
how to get the first row without using rank t/r?
Enlist few areas or real-time situations where informatica is required.
What is best approach to load 100 different source files (Different structure) to differet target tables ?
In a table, 4 person having same salary. How to get Third person record only?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How do we call shell scripts from informatica?
what is mystery dimension?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
WAT IS TEXT LOAD?
How to eliminate duplicate records in informatica mapping? Explain with an example....
Teradata 
