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
- 6014 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 |
What are the reusable transforamtions?
without using emailtask how will send a mail from informatica?
What are the types of lookup transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
can any one explain me about junk dimension
How do you take back up of repository?
Can we use the mapping parameters or variables created in one mapping into another mapping?
What is polling in informatica ?
How we can create indexes after completing the load process?
Without source how to insert record to target?
wt is Dynamic lookup Transformation? when we use?how we use?
Teradata 
