Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 12569 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yamini
Performance wise unconnected look up transformation is better as it returns only one port and doesn't build any dynamic cache. Only static cache is build. It can be used any where in the mapping using LKP expression in another transformation.
| Is This Answer Correct ? | 4 Yes | 0 No |
In target table how to display the system time
What is polling in informatica ?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to run a session, which contains mapplet?
What are the new features of informatica 9.x in developer level?
What is DR strategy for Informatica project?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
performance tuning of Informatica
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
Teradata 
