What is meant by lookup transformation?
- 1 Answers
- 1238 Views
- I also Faced
- E-Mail Answers
Answer / Vivek Chaudhary
Lookup Transformation in Informatica is a data integration tool used to join data from multiple sources or tables based on a common key. It allows you to reference and integrate data from other workflows, external files, or databases without having to physically move the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
COM components can be used in Informatica
What is power center repository?
What is the difference between source qualifier transformations source filter to filter transformation?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
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?
what is lookup chache?
How identifying bottlenecks in various components of informatica and resolving them?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
What is the difference between a repository server and a powerhouse?
Performance tuning( what you did in performance tuning)
Teradata 
