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
- 14400 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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is an Integration service in Informatica?
What is the difference between a connected look up and unconnected lookup?
What is a stored procedure transformation?
How will the document be delivered to me?
Explain the mapping variable usage example in informatica
How do you load only null records into target?
What are the differences between source qualifier and joiner transformation?
What is target load order?
Clarify the utilization of aggregator cache record?
can anyone explain me about retail domain project in informatica?
What are the components of Informatica? And what is the purpose of each?
Which is the t/r that builts only single cache memory?
which one is better performance wise joiner or look up
