Hello all,
I have a requirement to read a table, do some validations in a transformer and write a Sequential File, having as a File Name the Key field the table in the transformer.
So if I read 100 rows, I should have 100 TXT files, every file should be named with the primary key value of the table
Any idea how can i do that?
Thanks a lot in advance
Rgds
Create a TXT File with Row Value
Moderators: chulett, rschirm, roy
1)Identify the distinct Key values after validation and write the result into a textfile
2)Use execute command stage to convert the result obtained in first step into some pipe or comma delimiter output
3)use Loop activity stage for each distinct value of the key and use proper constraint to filter only one record during each iteration
2)Use execute command stage to convert the result obtained in first step into some pipe or comma delimiter output
3)use Loop activity stage for each distinct value of the key and use proper constraint to filter only one record during each iteration
-
- Premium Member
- Posts: 42
- Joined: Wed Aug 31, 2011 2:56 am
- Location: St. Gallen - CH
- Contact:
Thanks a lot ghuys, I just split the job as following.
1.- Job to create the hash with all data
2.- setting the userstatus with the @inrownum (to get the total rows)
3.- do a loop till @inrownum
4.- create a filename in every step
5.- loading the data for that filename=primary key
Thanks alot in advance
1.- Job to create the hash with all data
2.- setting the userstatus with the @inrownum (to get the total rows)
3.- do a loop till @inrownum
4.- create a filename in every step
5.- loading the data for that filename=primary key
Thanks alot in advance
MGS