Interested to Buy Any Domain ? << Click Here >> for more details...
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
- 6 Answers
- 11829 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / swarna.latha165
please tell me the solution
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
Repository user profiles
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 Create a folder using pmrep command?
How do you take back up of repository?
Please let me know how to make Data masking in informatica..
What is the need of an ETL tool?
What does update strategy mean, and what are the different option of it?
Explain the etl program with few examples.
How can a transformation be made reusable?
How can you differentiate between powercenter and power map?
What is deployment group?
What is sorter transformation?
What is informatica?
What are the different types of olap? Give an example?
