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
Explain what is informatica metadata and where is it stored?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain the pipeline partition with real time example?
What is rank transform?
what is the size of your data warehousing?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is DR strategy for Informatica project?
how many types of dimensions are available in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a router transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is data transformation manager process?
Describe the impact of several join conditions and join order in a joiner transformation?
Write the program through which the records can be updated?
scenario where i can use only concurrent execution of workflow.