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
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Difference between Target-based loading and constraint-based loading?
What is a connected transformation?
Enlist the various types of transformations.
What is the advantage of informatica?
How many transformations can be used in mapplets.
Explain how to import oracle sequence into informatica?
Which files are created during the session rums by informatics server?
Explain about Informatica server process that how it works relates to mapping variables?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Define mapping and session?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is meant by lookup transformation?
What are the transformations that are not supported in mapplet?