Interested to Buy Any Domain ? << Click Here >> for more details...
can we use self join in informaitca?
- 3 Answers
- 19531 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran ghatage
You can go through the following solution from Informatica Marketplace. You will also find over 400 mapping samples and many other useful tools on the same website.https://community.informatica.com/solutions/developer_client_self_join_using_joiner
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / ankit kansal
However joiner Trans does not support self join , but you can achieve similar functionality with the following steps.
1) create two expression transformation and input them using Source Qualifier.
2) Pull joiner transformation and join both two expression transformation using keys like mgrno = empno
3)NOTE:- check sorted input box and pull your data as ordered.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 2 No |
What are the different types of repositories created using informatica?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
what is Active lock explain
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
Design time, run time. If you don't create parameter what will happen
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
What is meant by LDAP users?
What do you understand by term role-playing dimension?
What is an expression transformation in informatica?
What is rank transform?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
Teradata 
