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.
- 5 Answers
- 16125 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
Using lookup is equivalent to outer join on source table.
As Bhavani said, if you want to join 2 heterogeneous
sources you cannot join in SQ. Then you need to use join.
Ex: you have 2 sources. One is a table in a DB and another
is a faltfile then you can only join using joiner.
Adv: you can perform operations similar to inner, left
outer, right outer and full outer. But using a lookup its
equivalent to left outer join on source.
It's always better to join a table which is small in SQ
then creating a lookup on it for better performance
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
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 will use SQL override in a lookup transformation?
Can u access a repository created in previous version of Informatica?
What is a mapping?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What is etl process?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
what is granularity in Data ware House?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
What are snapshots?
What is full load & incremental or refresh load?
In Which Transformation We Can Use Having Clause In Informatica?
Explain about round-robi?
