Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 13803 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / rayudu
Connected lookup is used to lookup on each and every row
bjut unconnected lookup is used to lookup only when the
condition is true i,e unconnetcec is used only for selectetd
rows so obviously unconnected is faster .
Regards,
rayudu.
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
What is a transaction control transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What are the advantages of informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is parallel processing in informatica?
Where can we find the throughput option in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
According to his methodology what all you need before you build a datawarehouse
What is the status code in stored procedure transformation?
What is different between the data warehouse and data mart?
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
pmscmd startworkflow -sv
whats the logic to load the lower level of granularity of data to fact table.
explan ur project architecture?
