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
- 11380 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 |
what is fact and what types of fact tables is there
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
what are the types of facts with Examples?
Filter transformation in the condition one of the data is NULL would the record be dropped.
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What is the difference between a router and a filter transformation?
what is lookup ?
What is update override?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
Which kind of index is preferred in DWH?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
What is parallel processing in informatica?
Teradata 
