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
- 11798 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / satish
Using REG_MATCH function we can check string....
Expersion trx create variable port FLAG = IIF(REG_MATCH(COL_NAME , [a-zA-Z]+,TRUE,FALSE)
router trx create port nd give condition FLAG=TRUE-------------connect to string target
Default group -----------------------------conn to( number,special char) trg
SQ-EXP-RTR-TRG
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is an aggregator transformation?
What does role playing dimension mean?
Differentiate between a database and data warehouse?
What are the transformations that are not supported in mapplet?
How do you remove duplicate records in informatica? And how many ways are there to do it?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how to load rows into fact table in data warehouse
How can we use batches?
What are mapplets? How is it different from a Reusable Transformation?
How can you differentiate between powercenter and power map?
Describe expression transformation?
Does an informatica transformation support only aggregate expressions?
Explain what transformation and how many are there in informatica?
