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.
Answer Posted / 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 |
Post New Answer View All Answers
What are the settings that you use to configure the joiner transformation?
What are some examples of informatica etl programs?
What is a standalone command task?
Target increases every day even though no new record was inserted
How we can use union transformation?
Write the different tools in the workflow manager?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain the etl program with few examples.
What is the Rank index port in Rank transformation?
How big was your fact table
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to use procedural logic inside infromatica?
Why filter transformation is an active one?