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
- 11168 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 |
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
Can you copy the session to a different folder or repository?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
what transformations are used for Variable port?
What is the sql query overwrite in source qualifier in informatica
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
why u go for dimensions ?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
How do you change a non-reusable transformation to reusable transformation?
Teradata 
