What is the use of unconnected lookup transformation in Informatica?
What is the use of unconnected lookup transformation in Informatica?
You can use an unconnected Lookup transformation to replace cryptic or numeric ID values in a table with meaningful names from a lookup table. For example, you need to load some sales order data from SAP transactional tables to a relational table in your data warehouse.
What are the advantages of unconnected lookup?
Reusability: An Unconnected Lookup Transformation is reusable within a mapping. Its performance is better than Connected Lookup transformation, because it returns only one output port.
What are the differences between connected and unconnected lookup?
Informatica – Difference between Connected Lookup & Unconnected Lookup
| Connected Lookup | Unconnected Lookup |
|---|---|
| Receives input values directly from the pipeline. | Receives input values from the result of a :LKP expression in another transformation |
| You can use a dynamic or static cache. | You can use a static cache. |
What is the difference between connected and unconnected transformation in Informatica?
Differences between Connected and UnConnected Lookup Transformation: Connected lookup receives input values directly from mapping pipeline, whereas UnConnected lookup receives values from the lookup expression from another transformation.
How to create an unconnected lookup in Informatica?
The county is a string that contains a county name. County_SalesTax is a decimal field that contains a tax rate for the county. The sales tax file is the lookup source. Step 2. Create the Unconnected Lookup Transformation
When to use the unconnected lookup in programming?
Please find below is the Unconnected Lookup Usage: The main advantage of using an unconnected lookup is the fact that you can use it in an expression/any other transformation like a “function” in other programming languages.
How to do an unconnected lookup in Excel?
If the county does not charge a sales tax, the Lookup transformation returns NULL. Call the lookup from an Expression transformation. Import a flat file physical data object that contains the sales tax amounts by county. Create the unconnected Lookup transformation.
Can You Help Me with lookup concept in MDM?
I have a confusion on lookup concept in MDM, Can you please help me. I have below Concerns/Questions 1) Lookup can be applied only on ROWID_OBJECT column in BO tables OR can apply on any column?