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
- 6144 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
Separate from a database, an information bazaar, and an information stockroom?
What is an expression transformation in informatica?
Explain the use of aggregator cache file?
What is rank transformation in informatica
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is session task and command task?
How to partition the Session?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Write the advantages of partitioning a session?
Differentiate between reusable transformation and mapplet.
What is the meaning of decode in informatica?
Enlist the tasks for which source qualifier transformation is used.
What is lookup change?
Why update strategy and union transformations are active?
