Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vamse
not necessarily left outer join. Its inner join most of the time.
Loop up is generally used to fetch data for a particular filter condition.(matching critria should take a particular value from it.
Main table is usually large and look up table is small in ideal scenario.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
what do u do when DB time takes more?in sap bi
what is granularity in Data ware House?
How many steps etl contains?
Identifying the bottlenecks in various components of Informatica and resolving them.
explain the methodology of Data Warehousing?(Polaries)
Is apache nifi an etl tool?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Two default user groups created in the repository are____and_____.
What is partitioning? Explain different types of partitioning?
What is a staging area? What is the purpose of a staging area?
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?
where we cannot use sorter Transformation. if we use then we will not get correct data?
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.?
What is full load & incremental or refresh load?
Explain etl?
