Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 2 Answers
- 7197 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / swathi
using source qualifier and also lookup transformation,
joiner lookup
--------------------------------------------
active t/r passive t/r
supports horizontal merging supports horizontal merging
supports only equi join both equi& non equi join
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Difference between flat files and relational sources?
What do you understand by active and passive transformations?
how to load the data to fact table?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
what are the reporting tools and difference between them?
Explain the difference between etl tool and olap tools?
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.?
Compare etl & elt?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Mention few test cases and explain them?
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 ?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What is initial load and what is full load?
Difference between flat files and relational sources?
What is meant by incremental load?
