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
- 2644 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
what do u do when DB time takes more?in sap bi
How many types of transformations supported by sorted input?
what is the difference steps for data modeling?
What is lookup table in etl testing?
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?
What is staging area referring to?
How many steps etl contains?
What is partitioning? Explain different types of partitioning?
explain the methodology of Data Warehousing?(Polaries)
What is meant by incremental load?
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?
what is the use of structures?how many nodes can u create in a structure?
Mention few test cases and explain them?
what is the meaning of upgradation of Repository?
When do we go for the tools in the market?
