- Posts: 290
- Thank you received: 1
Auto create "output" under transformation?
8 years 11 months ago - 8 years 11 months ago #11684
by orlandoc
Auto create "output" under transformation? was created by orlandoc
Greetings,
I have a file to read - it is a piped delimited file. But I have to read the total number of width per line as part of validation.
So I use the splitter after my validation. The Splitter will do the split based on piped delimited. The total number of fields are 138. The tedious part is to drag the "Output" connection node under Transformation and 138 of them. The Automap can produce the number of output but not mapping them. - see screen shot.
Is there a way or technique to generate number of "Output" based on the source number of fields? And then it is easy to manipulate after that. Please advise.
Thank you.
I have a file to read - it is a piped delimited file. But I have to read the total number of width per line as part of validation.
So I use the splitter after my validation. The Splitter will do the split based on piped delimited. The total number of fields are 138. The tedious part is to drag the "Output" connection node under Transformation and 138 of them. The Automap can produce the number of output but not mapping them. - see screen shot.
Is there a way or technique to generate number of "Output" based on the source number of fields? And then it is easy to manipulate after that. Please advise.
Thank you.
Last edit: 8 years 11 months ago by orlandoc.
Please Log in or Create an account to join the conversation.
8 years 11 months ago #11687
by admin
Mike
ETL Architect
Replied by admin on topic Auto create "output" under transformation?
If I was you I would create 2 transformations one to validate
data another to transform and run it from the package.
Mike
data another to transform and run it from the package.
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
8 years 11 months ago #11688
by admin
Mike
ETL Architect
Replied by admin on topic Auto create "output" under transformation?
If I was you I would create 2 transformations one to validate
data another to transform and run it from the package.
Mike
data another to transform and run it from the package.
Mike
Mike
ETL Architect
The following user(s) said Thank You: orlandoc
Please Log in or Create an account to join the conversation.