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
- 4822 Views
- I also Faced
- E-Mail Answers
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
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
In which transformation you cannot drag ports into it?
What are the designer tools for creating transformations?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
explain about unit testing? in real time?
difference between informatica 8.1.1 and 8.6
Different sorts of metadata that stores in the storage facility?
What are the features of complex mapping?
What are the different versions of informatica?
Explain why we use partitioning the session in informatica?
Explain joiner transformation in informatica
What are the steps involved in the migration from older version to newer version of Informatica Server?
Reusable transformation and shortcut differences
Why do we need informatica?
How to extract the informatica rejected data?
