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
Which version configuration tool used in ur project?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is a grid in Informatica?
What is informatica powercenter repository?
Explain the scenario which compels informatica server to reject files?
What do you mean by worklet?
What is dimensional table? Explain the different dimensions.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to load data in informatica ?
Could you explain what is enterprise data warehouse?
Which transformation should we use to normalise the COBOL and relational sources?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to do the error handling of if ur source is flatfiles?
What is the format of informatica objects in a repository?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?