i have two sources both is oracle database . one is coming
from USA database and another one is coming from U.k
database .i am using source qualifier transformation to join
this.as that time in session level source properties which
path i need to give to retrieve that data.

thanks
bala
09619894486

Answers were Sorted based on User's Feedback



i have two sources both is oracle database . one is coming from USA database and another one is c..

Answer / zer0

As far as I understand, you have 2 databases (both oracle).
You are trying to join table in say database1 (US) with
table in database2 (UK) using Source Qualifier. If you
really want to join using SQ, then create a view of the
table in db1 into db2 and then try joining the view and the
table in db2. Then in the session you will need to give the
connection setting of only db2.

If you dont like the view idea try using Joiner
Transformation. Joiner Transformation is a stright forward
method in Informatica.

Please let me know if it works.

Is This Answer Correct ?    9 Yes 0 No

i have two sources both is oracle database . one is coming from USA database and another one is c..

Answer / raj

Even we can achieve this by using DBlink concept
for eg:CREATE DATABASE LINK local
CONNECT TO hr IDENTIFIED BY hr
USING 'local';
here
local is an instance name and hr is a schema name, now you
can access both the databases at a single database and you
can give one single source connection in the session
properties..

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More Informatica Interview Questions

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,


My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  


In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,


What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,


we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,






what is flat file override?

1 Answers   Cap Gemini, HP,


How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  


how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,


What are the components of the workflow manager?

0 Answers  


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  


in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,


Categories