Transformer Object Only Allows 4 Output Fields to map to

More
4 years 10 months ago #21375 by ipitzey
Hi,

I am trying to extract records from a database to a flat file.
My SQL statement contains 6 fields.
The validation task pick up all these field and maps them correctly.
The transformer picks up all the source fields, but only supplies 4 output object fields.
When you add the additional output objects and map them and save it, upon returning to the transformer object, the new output fields are removed along with their mapping.

Is this a bug, or am I not doing something?

If anyone can help, it would greatly be appreciated

.
Thanks.......
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago #21376 by admin
When the transformer is connected to the writer it takes the list of output fields from it.


We have a number of videos dedicated to working with writer you may find them useful.

Please keep us posted on your progress

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago #21377 by ipitzey
Hi Mike,

Thanks for the Response.

Yes this worked. I was using the graphic interface to add an output field in the Transformer object, which doesn't work.
Once I selected the Writer{} tab and added the new field(s) in the writer tab, this then is mappable in the Transformer object.

Many thanks for you response.
Ian
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save