Why we use partitioning the session in informatica?
Answers were Sorted based on User's Feedback
Answer / swetha
Partitioning achieves the session performance by reducing
the time period of reading the source and loading the data
into target.
Is This Answer Correct ? | 14 Yes | 8 No |
Answer / honey
The PowerCenter® Partitioning Option increases the
performance of PowerCenter through
parallel data processing, and it has been instrumental in
establishing PowerCenter’s industry
performance leadership. This option provides a thread-based
architecture and automatic data
partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware
environments
Is This Answer Correct ? | 3 Yes | 0 No |
What is informatica metadata and where is it stored?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Name 4 output files that informatica server creates during session running?
Which transformation should u need while using the cobol sources as source defintions?
What is mapplet and a reusable transformation?
what is work of PUSH DOWN option
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
What are the limitations of joiner transformation?
what happens when a batch fails?
Do you find any difficulty while working with flat files as source and target?
How many ways are there to do 'remove duplicate records in informatica'?
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me