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 |
What is rank transformation in informatica
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
how DTM buffer size and buffer block size are related
What is an active 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 ?
What is confirmed fact in dataware housing?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
Diff b/w ShortCut and reusabel Object ?
Can any one explain or sujjest some sites for scd mappings.Thank you
what is the drillup & drill down?and use of the drill up and drill down?
What is joiner transformation in informatica?