How to join the source data having 100 million records?

Newbie003242 Lv1Posted 03 Jun 2023 14:29

In Informatica PowerCenter, the normal join is working for the src file having data of 10000 records, but it's throwing an error for 100 million src records. How should I fix this issue?

I have enabled the sorted port in joiner and have even added a sorter before joiner and have sorted the ports which are the same in both the sorters I have used. I am getting the error as(no ports are sorted)

By solving this question, you may help 77 user(s).

Posting a reply earns you 2 coins. An accepted reply earns you 20 coins and another 10 coins for replying within 10 minutes. (Expired) What is Coin?

Enter your mobile phone number and company name for better service. Go

I Can Help:

Change

Moderator on This Board

4
0
1

Started Topics

Followers

Follow

Trending Topics

Board Leaders