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
- 11568 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 tasks that can be performed using sq?
What are the prerequisite tasks to achieve the session partition?
What are the measure objects?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How we can create indexes after completing the load process?
How do you load unique records into one target table and duplicate records into a different target table?
Explain the pipeline partition with real time example?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to start a workflow using pmcmd command?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the types of lookup transformation?
What is difference between a gateway node and worker node?
Plz can any one say me how to get the informatica certification materials and dumps
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
