Interested to Buy Any Domain ? << Click Here >> for more details...
1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
- 10 Answers
- 14137 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sunny
select substr(
(select substr('123*456*789', 1 ,
instr('123*456*789','*',1,2)-1) from dual)
,instr(
(select substr('123*456*789', 1 ,
instr('123*456*789','*',1,2)-1) from dual)
,'*',1)+1) from dual;
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is aggregator transformation in informatica?
How do you load first and last records into target table?
Different circumstance which drives informatica server to expel records?
What are different types of transformations available in informatica?
What is dimensional table? Explain the different dimensions.
How can we delete duplicate rows from flat files?
Is it possible to define a single node as a Gateway node as well as worker node?
Where do we use mapping variables in informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
How can you generate reports in informatica?
Explain joiner transformation in informatica
What is joiner transformation in informatica?
design of staging area?
Describe expression transformation?
What is option by which we can run all the sessions in a batch simultaneously?
