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 |
How to load the source table into flat file target(with columns) in informatica?
How we can confirm all mappings in the repository simultaneously?
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?
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.
what is the look up transformation?
Differentiate between router and filter transformation?
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?
What do you understand by term role-playing dimension?
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?
Enlist the differences between database and data warehouse.
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?
what is the difference between informatica6.1 and infomatica7.1