how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answer Posted / abhishek kumar
using union transformation.........
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the key benefits of ETL Testing?
Explain etl mapping sheets?
what is the meaning of upgradation of Repository?
How etl testing is different from database testing?
What is a staging area? What is the purpose of a staging area?
how does the server recongnise the source and target databases.Elaborate on this
how would u estimate the size of Aggregator transform data and index cache?
What is initial load and what is full load?
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 ?
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
How can we use external procedural logic in informatica?
What is tracing level and what are the types?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
When do we analyze the tables?
where is the cache (lookup, index) created and how can you see it.