I have 4 columns in a table say, name ,address, salary and city. So based on d

I have 4 columns in a table say, name ,address, salary and
city. So based on distinct city names, i need to combine
the other data and send it to a flat file. Distinct city
names can be 4 or 5 or 6. So it has to dynamically generate
flat files(4 or 5 or 6) corresponding to the city names.

Question Posted / sachdeva.nancy@gmail.com

2 Answers
4821 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, ..

Answer / ankit kansal

steps:-
1)Bring source and target into a mapping
*remember to check the target file name option in target analyzer window for that target.
2)sort your data on the basis of city.
3)In expression transformation
o_flag-----o---IIF(prev_city=city,0,1)
prev_city--v---city
o_file_name--o--city
*remember the order must be same
4)Take Transaction Control
IIF(o_flag=1,TC_COMMIT_BEFORE,TC_CONTINUE_TRANSACTION)

i hope it helped you.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?

2 Yes

0 No

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, ..

Answer / hari

transaction control transformation will do this logic
dymanically.
using shell programming we can split those files using post
command task

Is This Answer Correct ?

1 Yes

0 No

Post New Answer