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
- 2689 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
How can we use external procedural logic in informatica?
What are the modules in Power Mart?
What are the various tools used in etl?
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?
how many steps are there in etl process?
Difference between flat files and relational sources?
how would u estimate the size of Aggregator transform data and index cache?
how do u identify the changed records in operational data?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
Explain about hash partitioning?
Explain etl mapping sheets?
How many steps etl contains?
What is meant by incremental load?
Explain etl?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
