1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
- 10 Answers
- 12607 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 are Dimensional table?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
how to create user defined function (udf) in informatica
What is the use of an aggregator cache file?
define galaxy repository in informatica
How might you approve all mappings in the archive all the while?
What is an active transformation?
What is the use of transformation?
Briefly describe lookup transformation?
What is a sorter transformation?
Explain scd type 3 through mapping.
Repository user profiles
What do you mean incremental aggregation?
How can we use mapping variables in informatica? Where do we use them?
Mention few advantages of router transformation over filter transformation.
