how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answers were Sorted based on User's Feedback
Answer / kasi reddy
using lookup T/R we can join the two tables and using
source qualifier t/r we can join the table
Is This Answer Correct ? | 3 Yes | 1 No |
list and discuss two approaches for updation of target table in Informatica and how they are different.
Explain what are the various etl tools in the market?
how do use session mapping parameters ?(in which transformation)
how do u implement unconn.stored proc. in a mapping?
How etl testing is different from database testing?
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.?
Explain etl?
What is full load & incremental or refresh load?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Mention few test cases and explain them?
what is meant by drill through?(Mascot)
What is data modeling and data mining?