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?
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 you know when to use a static cache and dynamic cache in lookup transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is InformaticaPowerCenter?
What is the maplet?
What are multi-group transformations?
What is rank transformation?
What is a filter transformation?
Differentiate between a repository server and a powerhouse?
generate date / time dimension in informatica
What are the new features of informatica 9.x at the developer level?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is expression transformation?
What is different between the data warehouse and data mart?
What is the need of etl tools?