1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

i have source in oracle 10g,oracle 8i how will u take the
data
from two sources

Question Posted / venkat

Answers were Sorted based on User's Feedback



i have source in oracle 10g,oracle 8i how will u take the data from two sources..

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

i have source in oracle 10g,oracle 8i how will u take the data from two sources..

Answer / rams

Will get two sources data through DB link in relational databases

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

star and snowflake schema?

6 Answers  

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  




How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

When do you use mapping parameters? (In which transformations)

1 Answers  

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

What are the different types of schemas?

11 Answers   ITC Infotech,

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

For more Informatica Interview Questions Click Here
Categories