i have source in oracle 10g,oracle 8i how will u take the
data
from two sources
Answers were Sorted based on User's Feedback
Answer / gm
There is no problem for extracting data from oracle 10g or
8i. using userid/pwd. u can get the data from both sources.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / rams
Will get two sources data through DB link in relational databases
| Is This Answer Correct ? | 0 Yes | 0 No |
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
How do you implement unconn. Stored proc. In a mapping?
how i will stop my workflow after 10 errors
What all join we can perform in LOOKUP transformation?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
How do you load only null records into target?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,