Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / krishna
Yes we can use self join informatica using SQL override..
and remember Joiner transformation does not support for self
join..
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What are the informatica performance improvement tips
How does a sorter cache works?
Define mapping and session?
What all join we can perform in LOOKUP transformation?
How you can differentiate between connected lookup and unconnected lookup?
What all are steps in up gradation of Informatica server?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain pmcmd command usage in informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the data movement modes in informatica?
what is the Default Source Option For Update Strategy Transformation?
What are the differences between a connected lookup and unconnected lookup?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
