Interested to Buy Any Domain ? << Click Here >> for more details...
After draging the ports of three sources(sql
server,oracle,informix) to a single source qualifier, can
you map these three ports directly to target?
- 6 Answers
- 12769 Views
- I also Faced
- E-Mail Answers
Answer Posted / bidhar
You cannot join Hetrogeneous sources in a SQ.For that you
need use joiner.For example if you have n hetrogeneous
sources then you must use n-1 joiners.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to differentiate between the active and passive transformations?
Explain in detail scd type 2 through mapping.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is unit testing?tell me proceedure
How do you load alternate records into different tables through mapping flow?
What is depict expression change?
4 yrs etl devloper roles and responsibilities?any body give solutions
list out all the transformations which use cache?
What are the reusable transformations?
How can you generate reports in informatica?
Explain scd type 3 through mapping.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
