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
- 12019 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
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 session task and command task?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Why filter transformation is an active one?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the sql query overwrite in source qualifier in informatica
What are the different clients of powercenter?
pmscmd startworkflow -sv
have u done any performance tuning? how u ll do?
How do you migrate data from one environment to another?
What are the differences between a connected lookup and unconnected lookup?
What is Index Caches size?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the function of union transformation?
