Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, ..

Answer / ankit kansal

steps:-
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
o_flag-----o---IIF(prev_city=city,0,1)
prev_city--v---city
o_file_name--o--city
*remember the order must be same
4)Take Transaction Control
IIF(o_flag=1,TC_COMMIT_BEFORE,TC_CONTINUE_TRANSACTION)


i hope it helped you.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    2 Yes 0 No

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, ..

Answer / 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

More Informatica Interview Questions

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  


Difference between Data and Index Caches?

0 Answers   Informatica,


Mention some types of transformation?

0 Answers  


1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,


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

3 Answers  






What are the designer tools for creating transformations?

0 Answers   Informatica,


Explain the mapping variable usage example in informatica

0 Answers   Informatica,


Can we make worklet inside worklet?

1 Answers  


Can we override a native sql query within informatica?

0 Answers  


daily how much amount of data send to production?

4 Answers   HSBC,


How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,


If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,






Categories