i hit the database it show 4 row in database but it return only 2 . so help me
You need to join your "main" CountryCode column to your "lookup" CountryCode column and carry out an inner join. Your web service is erroring because you are returning every row of your lookup. REST services are only supposed to respond once per call. Of course you might want all of your lookup rows returned in one big XML output. If that is the case you need to set "All in one" to true in your response output. That will allow your XML to hold a look per lookup.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach