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
Enlist the differences between database and data warehouse.
What is a sorter transformation?
What do you mean by blocking transformation?
How to join three sources using joiner? Explain though mapping flow.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How we can create indexes after completing the load process?
What is a filter transformation?
Is it possible to create multiple domains on a single Informatica server?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are active transformations.
Parameter and variable differences
Write the different tools in the workflow manager?
What are the transformations that are not supported in mapplet?
Why filter transformation is an active one?