Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 6172 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Whats the difference between informatica powercenter server, repositoryserver and repository?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Differentiate between a repository server and a powerhouse?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Enlist some properties of sessions.
What are the modules in Power Center
What is session task and command task?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
how tokens will generate?
What are connected or unconnected transformations?
how to load rows into fact table in data warehouse
How we can create indexes after completing the load process?
difference between informatica 8.1.1 and 8.6
Informatica settings are available in which file?
permutations of mapplet
