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



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

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,


How we can confirm all mappings in the repository simultaneously?

1 Answers  


In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,


Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  


what is the look up transformation?

2 Answers   Informatica,






Differentiate between router and filter transformation?

0 Answers  


If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,


What do you understand by term role-playing dimension?

0 Answers  


we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  


Enlist the differences between database and data warehouse.

0 Answers  


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


Categories