Interested to Buy Any Domain ? << Click Here >> for more details...
What is a diff between joiner and lookup transformation
- 16 Answers
- 95927 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / prasanna
Joiner is active transformation in informatica to merge
nonsimilar structures into target warehouse systems.
Joiner needs a condiotion for data merging based on
following types
1.Normal join
2.Maste outer join
3.Detail outer join
4.Full outer join
Lookup is a passive transormation in informatica.this
transformation is used for data verfications of the source
table in assign lookup table
Lookup needs a condition if the condition is satisfied
returns corresponding data else returns null value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How many transformations can be used in mapplets.
What is the format of informatica objects in a repository?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
According to his methodology what all you need before you build a datawarehouse
How to extract sap data using informatica? What is abap? What are idocs?
Write the unconnected lookup syntax?
What does cheating measurement mean?
What is a stored procedure transformation?
What is the different lookup cache(s)?
What is rank index in rank transformation?
What is the difference between a repository server and a powerhouse?
How does a sorter cache works?
Differences between connected and unconnected lookup?
