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
- 12024 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
what is data modelling? what are types of modelling?In which suituation will use each one?
what is dynamic cashe
What are Dimensions and various types of Dimensions?
What is the difference between a router and a filter transformation?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
how to get max value record into one target and remaining records into another target?
How to merge First Name & Last Name?
Different types of Power center errors?
Can you create a flatfile target
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain lookup transformation is active in informatica
Teradata 
