Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / raveendra guturi
Union: while we have to join two sources should data
structure same.
)Joiner is active transformation
Lookup is a passive transformation
2)In joiner we can join two heterogeneous sources for
entire Records based on a condition.
But in look up only the first value or last value of the
Records will be passed if more records matched with that
condition. So only one value will be returned to the
transformation.
3)If we need entire values we must go for joiner. Take that
look up table as source and use joiner. No alternative
Solution.
4) Joiner operates on source
Lookup operates on source and target level
5) Joiner does not support non-eqijoin its support equijoin.
Lookup supports non-equijoin
6) Joiner doesnot match for null values
Lookup supports null values
7) join supports only = operator
Lookup supports <=,>=,=,1= operators
9) Joiner supports outer join but lookup doesnot.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what are the deliverables?in your project?
What do you mean incremental aggregation?
What are the different types of repositories created using informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the informatica performance improvement tips
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the designer tools for creating transformations?
How do you load alternate records into different tables through mapping flow?
what are the Methods For Creating Reusable Transformations?
If informatica has its scheduler why using third party scheduler?
How can we use batches?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are mapplets? How is it different from a Reusable Transformation?
