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
- 16473 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
What are three tier systems in etl?
what are the session parameters? How do u set them?
what is the difference between cardinality and Nullability?
Explain about round-robi?
Do we need an ETL tool? When do we go for the tools in the market?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what are the types in error loging?
What is etl process?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What are the ETL Testing Operations?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
Two default user groups created in the repository are____and_____.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Explain about power designer data modeling software?
What is a mapping?
