I try to pull data from Salesforce via bulk query (via tSalesforceInput).
I use a "manual query", which is structured as follows:
Select Id, Contact.Id, Account.Id, Contact.Name, Contact.LastName, Contact.FirstName, Account.Name from User where isactive=true and Contactid != null
I created the corresponding schema according to the syntax, i.e. User_Contact_id, User_Account_Name etc..
If the component runs in query mode "bulk", all non-user fields are null.
If the component runs in query mode "query", all non-user fields are filled.
Is this an intended behavior and is it possible to get the bulk mode work with the manual query?
We use Integration Studio 6.4.1.
If you have less than 50,000 rows, don't use bulk (not necessary).
Don't why the result is different in your case.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables