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.
Answers were Sorted based on User's Feedback
Answer / ankit kansal
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
*remember the order must be same
4)Take Transaction Control
i hope it helped you.
|Is This Answer Correct ?||2 Yes||0 No|
Answer / hari
transaction control transformation will do this logic
using shell programming we can split those files using post
|Is This Answer Correct ?||1 Yes||0 No|
how to identify new and old values in source qualifier or any other transformations using informatica
Difference between Data and Index Caches?
Mention some types of transformation?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
What are the designer tools for creating transformations?
Explain the mapping variable usage example in informatica
Can we make worklet inside worklet?
Can we override a native sql query within informatica?
daily how much amount of data send to production?
How to handle changing source file counts in a mapping?
If the records doesnt satisfy the filter condition where will it go?