How the informatica server increases the session performance
through partitioning the source?
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 |
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
whether Sequence generater T/r uses Caches? then what type of Cache it is
What is a mapplet/worklet in informatica?
how we do performence tuning in informatica
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
How to create a non-reusable instance of reusable transformations?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
Define informatica repository?
can anyone explain me about retail domain project in informatica?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.