Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7273 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Differentiate between a database and data warehouse?
what are the settiings that u use to cofigure the joiner transformation?
How can you run a session without using server manager?
How do you take care of security using a repository manager
wf dont have integration severances how you can run?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
According to his methodology what all you need before you build a datawarehouse
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
where to store informatica rejected data? How to extract the informatica rejected data?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
Teradata 
