Interested to Buy Any Domain ? << Click Here >> for more details...
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
- 6 Answers
- 19413 Views
- HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / prasadreddy
by using the dummy ports u can do..but the both the data
types should be same
| Is This Answer Correct ? | 2 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
How do you change a non-reusable transformation to reusable transformation?
Which files are created during the session rums by informatics server?
What the difference is between a database, a data warehouse and a data mart?
Tell me about MD5 functions in informatica
What are the types of presistent cache in look up tr.
How does the aggregator transformation handle null values?
tell me 5 session failure in real time how can you solve that in your project?
what is the complex transformation you used in informatica
Define pmcmd command?
What is the use of target designer?
What are the conditions needed to improve the performance of informatica aggregator transformation?
what is Active lock explain
What do you understand by SOA of Informatica?
What is exclusive and normal mode for repository services?
