Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Differences between connected and unconnected
lookup?
- 6 Answers
- 21352 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / varma koilada
Connected lookup participates in the mapping ( dataflow )
just like any other transformation. Unconnected lookup is
used when a lookup function is used instead in an expression
transformation in the mapping in which case the lookup does
not appear in the main flow ( dataflow ) of the mapping.
Connected lookup can return more than one value ( output
port ) whereas Unconnected gives only one output port.
Unconnected lookups are reusable.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What are the components of Informatica? And what is the purpose of each?
Why do we need informatica?
Explain the difference between mapping parameter and mapping variable?
Describe the impact of several join conditions and join order in a joiner transformation?
What are ETL Tools?
How to load the data from people soft hrm to people soft erm using informatica?
Explain the aggregator transformation?
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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the Process to creating lookup transformation in informatica
What is flashback table ? Advance thanks
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
In informatics server which files are created during the session rums?
can u any challenge your project?
