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
- 11844 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 |
What is a command that used to run a batch?
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
Explain joiner transformation in informatica
Mention a few design and development best practices for informatica?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
how to delete duplicate records by using filter transfermation?
what is correlated query?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the Hierarchy of DWH?
How many numbers of sessions can one group in batches?
How do you use reject loader.
Teradata 
