i have source in oracle 10g,oracle 8i how will u take the
data
from two sources
- 2 Answers
- 4603 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
what is the difference between stop and abort
Explain one complecated mapping?
What is the filename which you need to configure in UNIX while installing infromatica?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
How can yoU improve session performance in aggregator transformation?
In which scenario did u used Mapping variable?
Where do you create/define mapping parameter and mapping variable?
How an expression transformation differs from aggregator transformation?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
How many types of sessions are there in informatica.please explain them?
what type of transformation is not supported by mapplets?
Teradata 
