1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
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
How do we call shell scripts from informatica?
What is the difference between Active and Passive transformation?
Write the different tools in the workflow manager?
What is Index Caches size?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the difference between informatics 7x and 8x and what is latest version?
Please let me know how to make Data masking in informatica..
What is a surrogate key?
Which are the different editions of informatica powercenter that are available?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is the hint? how to use it to reduce the query processing in program?
Is it possible to create multiple domains on a single Informatica server?
How is union transformation utilized?
What are batches?
Which development components of informatica have the highest usage?