Performance wise which is better joiner or look up ?
Give me with example?
- 1 Answers
- 10457 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 |
Using Expression transformation how to remove duplicate records from a relational source?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
How to generate sequence numbers without using the sequence generator transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
Where do you create/define mapping parameter and mapping variable?
What is polling?
how to through logic of informatica using the push down optimization into oracle.
What are active transformations.
What is the way to execute pl/sql script using informatica mapping?
what is the logic will you implement to load data into a fact table from n dimension tables?
What is the Difference between sorter and aggregator?
Teradata 
