what is the mechanism of the Master-Detail joining
condition?
Answer Posted / jay
I guess it is a Left OUTER join.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain why we use partitioning the session in informatica?
Explain how to import oracle sequence into informatica?
Define update strategy?
What is a grid in Informatica?
Repository user profiles
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what are 3 tech challenges/ common issues you face?
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 can we improve session performance in aggregator transformation?
What are mapplets?
How to update source definition?
How identifying bottlenecks in various components of informatica and resolving them?
What is main use of mapplet?
expain about the tune parameters?