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

Answer / krishna

Yes we can use self join informatica using SQL override..
and remember Joiner transformation does not support for self
join..

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/

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

What is an aggregator transformation?

0 Answers  

---

How to generate the HTML output using Informatica.

3 Answers   Wipro,

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  

---