Interested to Buy Any Domain ? << Click Here >> for more details...
Performance wise which is better joiner or look up ?
Give me with example?
- 1 Answers
- 11289 Views
- CGI, I also Faced
- E-Mail Answers
Answer / abhinaw prakash
There is no definite answer to this.But if we are using
homogenous data sources its better to use Look up rather
than joiner.
Again Look up can only perform left outer join.So for other
Join we have to use Joiner.
| Is This Answer Correct ? | 3 Yes | 3 No |
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
What you know about transaction control transformation?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
What is exclusive and normal mode for repository services?
How to load data in informatica ?
What are the scheduling options to run a sesion?
Target increases every day even though no new record was inserted
How can yoU create or import flat file definition in to the warehouse designer?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
what is confirmed dimension?
what is dimension table?
Teradata 
