Interested to Buy Any Domain ? << Click Here >> for more details...
How will you display 10-15 letters from a name? (for ex:
name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
- 4 Answers
- 8784 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
by using thie function sbustr(column_name,10,15) in the exp
t/r, u can get the output.
| Is This Answer Correct ? | 21 Yes | 1 No |
Answer / gyana
SUBSTR(COLUMN_NAME,STARTING POSITION(10),NUMBER OF CHARACTER YOU WANT(5));
IT WILL GIVE YOU THE OUT PUT 10TH POSITION TO 15 TH CHARACTER STRING
| Is This Answer Correct ? | 2 Yes | 0 No |
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
What is A complex mapping?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
What is a filter transformation and why it is an active one?
What is the main difference between a Joiner Transformation and Union Transformation?
Scheduling properties,whats the default (sequential)
what happens if you try to create a shortcut to a non- shared folder?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
Teradata 
