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
tell me about your project functionality
How to extract sap data using informatica?
How to go to the older version for a mapping?
Explain the etl program with few examples.
What are the different versions of informatica?
According to his methodology what all you need before you build a datawarehouse
Differentiate between a repository server and a powerhouse?
How to convert multiple rows to single row (multiple columns) in informatica
What are the databases that informatica can connect to windows?
how to load dimension table and fact table. plz tell me the steps.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is a filter transformation?
Define update strategy?
What is transformation?