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 is degenerated dimension?
What is dimensional table? Explain the different dimensions.
What are the restrictions of union transformation?
What are connected or unconnected transformations?
What do mean by local and global repository?
When do you use sql override in a lookup transformation?
define galaxy repository in informatica
What is a repository manager?
Explain the different lookup methods used in informatica?
What is confirmed fact in dataware housing?
How to convert multiple rows to single row (multiple columns) in informatica
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What are the issues you have faced in your project? How did you overcome those issues?
draw informatica architecture 8.6 ?
In which transformation you cannot drag ports into it?