Interested to Buy Any Domain ? << Click Here >> for more details...
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
- 2 Answers
- 3797 Views
- Accenture, Saama Tech, TCS, I also Faced
- E-Mail Answers
Answer Posted / bhavemanali10
Joiner Transformation is better in case of heterogeneous join(join 2 tables exist in the different database).
While lookup and SQ is better approach to join two tables which exist in same database
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain different types of partitioning?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Define Dynamic push down optmization?
what are the reporting tools and difference between them?
What are the types of Data Warehouse applications?
can be used COM component in Informatica ?
Mention few test cases and explain them?
what is a worklet?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Can there be sub steps of etl steps?
where is the cache (lookup, index) created and how can you see it.
What is a staging area? What is the purpose of a staging area?
what is the meaning of upgradation of Repository?
