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
- 6062 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How to join three sources using joiner?
How do you join more than 3 flat files in informatica?
What are the new features of informatica 9.x in developer level?
What are the issues you have faced in your project? How did you overcome those issues?
can every transfomation reusable?how?
How to delete the data in the target table after loaded.
How to load the data from a flat file into the target where the source flat file name changes daily?
what is DSS?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
Define the various join types of joiner transformation?
How the facts will be loaded? explain
Teradata 
