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
Explain how to import oracle sequence into informatica?
what is informatica metadata?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is rank transformation in informatica
What are the different lookup cache(s)?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is the session task and command task?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is domain in terms of informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are mapplets?
Informatica Checkpoints
What is deployment group?
Explain in detail about scd type 1 through mapping.
Differences between connected and unconnected lookup?