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?
Answers were Sorted based on User's Feedback
Answer / vijaya
By using function isnumber(), is string() in expression editot you get the solution
Is This Answer Correct ? | 6 Yes | 4 No |
Answer / santosh kumar sarangi
1.in expression t/r create one more port as below.
FLAG(integer)=IIF(LOWER(COL1)=UPPER(COL1) ,1,0)
2.Link the original port and FLAG port to router and create
a group as FLAG=1
3.Link the original port from the group to target of number
or special charater and default to target of character.
Let me know if any things wrong
Thanks and Regards
Santosh
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kamlesh mishra
Use is_number(field) and not is_number(field) functions in router transformations
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / davan
In expresion t/r just give data type as string only...
Is This Answer Correct ? | 0 Yes | 4 No |
How can we get multiple output values using an unconnected lookup transformation?
what is difference between mapping and mapplet ?
From where we can start or use pmcmd?
What is DTM process?
If we are using an aggregator but forget to mention the group by port .what will be the output??
What is critical mapping?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
waht type of interface is used for testing the data in informatica
If I am having 6 flat files in data. How can you load the data at a time
can anyone explain me about retail domain project in informatica?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
what is the exact meaning of domain?