I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
Answer Posted / kvikas2056
Thank you manali,
But can you please explain why joiner is better than lookup??
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain do we need an etl tool? When do we go for the tools in the market?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Explain what are the various etl tools in the market?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Explain me ETL project architecture in Detail?
how do use session mapping parameters ?(in which transformation)
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
When do we go for the tools in the market?
what are the reporting tools and difference between them?
How can we use external procedural logic in informatica?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
what is the meaning of upgradation of Repository?
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 ?
can cubes contain measures ?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture