can we use self join in informaitca?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of transformations available in informatica?

581


What are junk dimensions?

630


What are the types of schemas we have in data warehouse and what are the difference between them?

518


What is a surrogate key?

558


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7671






What do you mean by filter transformation?

550


What is intricate mapping?

586


How do you update the records with or without using update strategy?

660


What is primary and backup node?

693


How can we store previous session logs?

565


what is the size of your data warehousing?

1669


How do you change a non-reusable transformation to reusable transformation?

593


Design a mapping to load the cumulative sum of salaries of employees into target table?

890


Can you generate sequence numbers without using the sequence generator transformation?

597


server hot-ws270 is connect to Repository B. What does it mean?

1853