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
- 6264 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
What are the tasks that can be performed using sq?
What are the differences between source qualifier and joiner transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the different components of powercenter?
permutations of mapplet
What does command task mean?
Different qualification between a related rotate toward the sky and isolates look upward?
What is Index Caches size?
Separate from an archive server and a powerhouse?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
how to load dimension table and fact table. plz tell me the steps.
What are the modules in Power Center
What do you mean incremental aggregation?
Explain lookup transformation is active in informatica
list out all the transformations which use cache?
