How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 13930 Views
- I also Faced
- E-Mail Answers
Answer Posted / niroshreddy@gmail.com
hello hero's dont send wrong answers ..................
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is resilience time?
What are the modules in Power Center
what is the complex transformation you used in informatica
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is domain and gateway node?
Explain lookup transformation source types in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a dimensional model?
what is index?how it can work in informatica
Mention some types of transformation?
Write the unconnected lookup syntax and how to return more than one column.
lookup transformation with screenshots
