Interested to Buy Any Domain ? << Click Here >> for more details...
How can we get two output ports in un-connect transformation?
- 2 Answers
- 7368 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / prabhu
You can use lookup override to concat two columns from tble
and return as single column(eg COL1||','||col2 as
COLUMN).You can pass this to expression transformation and
parse it to split it again
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the use of transformation?
What is the reusable transformation?
What does refresh system mean, and what are its distinctive choice?
Differentiate between joiner and lookup transformation?
Is stop and abort are same in informatica?
COM components can be used in Informatica
What is the different lookup cache(s)?
How big was your fact table
How to call shell scripts from informatica?
What does reusable transformation mean?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to extract sap data using informatica? What is abap? What are idocs?
How would you join a node to the already existing domain?
How to use pmcmd utility command?
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
