Performance wise which is better joiner or look up ?
Give me with example?
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 |
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
what is degenerated dimension
r u done any partitions in ur project?
What is the need of etl tools?
what is bridge tables in informatica
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
What is tracing level and what are the types of tracing level?
What is partioning?how many types of partinings are there
What is the use of target designer?
Do you have to change the reject file b4 using reject loader utility.
Differentiate between a repository server and a powerhouse?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?