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
- 12017 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / vijaya
By using function isnumber(), is string() in expression editot you get the solution
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
How union transformation is used?
How do you handle two sessions in Informatica
Is there any target staging area in informatica not staging area
What is the sql query overwrite in source qualifier in informatica
What are the new features of informatica 9.x at the developer level?
Explain the different lookup methods used in informatica?
What is decode in static cache?
write a query to retrieve the latest records from the table sorted by version(scd)
What does role playing dimension mean?
differences between service based and product based?
is it possible to index the data in cache of lkp transformation ?
In how many ways we can create ports?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
explain one complex mapping with logic? sales project?
What are the different clients of powercenter?
