Interested to Buy Any Domain ? << Click Here >> for more details...
tell me the push down optimization
- 2 Answers
- 5670 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagaraju
push down optimization is used increase the performance.in this concept integration service convert the transformation logic into query and send to the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / akhil4
this option available in session(work flow) properties.
it increase informatica server performance.
when ever u enable this option it created view in database related to logic.(MEANS YOU TAKEN SEVERAL T/R IN THIS U HAVE IMPLEMENTED LOGIC USING THAT LOGIC IT WILL CREATE A VIEW)
U START WF IT TAKE THE DATA DIRECTLY TO SQ AND PUSH DATA THROUGH LOGIC AND LODES INTO TARGET.
| Is This Answer Correct ? | 0 Yes | 3 No |
how eliminate the duplicates in flat file with out using sorter ,aggregater
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
what is mean by complex business rule ?
How to update a particular record in target with out running whole workflow?
What is the Rank index port in Rank transformation?
If the records doesnt satisfy the filter condition where will it go?
What is hash partition?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
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 types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Can you start a batches with in a batch?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
Teradata 
