Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi I have a source (flat file) like



ID Name Attachments

101 abc [07012005072902]_CMM27-11-01 Page106
(2).pdf

102 bcd "[19012005124259]_Anfrage-Vendors.doc
[19012005124336]_Anfrage.xls"

103 def "[19012006092602]_IMG_0310.JPG
19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG
[19012006092727]_IMG_0313.JPG"



But I need to generate duplicate records based on
attachments column.



Target (Table) like



ID Name Attachments

101 abc [07012005072902]_CMM27-11-01 Page106
(2).pdf

102 bcd 19012005124259]_Anfrage-Vendors.doc

102 bcd [19012005124336]_Anfrage.xls

103 def [19012006092602]_IMG_0310.JPG

103 def [19012006092631]_IMG_0311.JPG

103 def [19012006092702]_IMG_0312.JPG

103 def [19012006092727]_IMG_0313.JPG

103 def [19012006092750]_IMG_0314.JPG

103 def [19012006092814]_IMG_0315.JPG





Here no. of Attachments we can't decide because it is
dynamic.



It will be great if somebody help me on this.





Thanks in Advance.
ganga

Question Posted / sreepathi

Answer Posted / sreepathi

Well make the (id, attachment) as unique or primary key
instead of id being primary key. Hope this solves you
problem, if not come out with clear requirement.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a filter transformation and why it is an active one?

961

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2092

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1911

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2396

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

995

How to convert multiple rows to single row (multiple columns) in informatica

1367

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1025

What differs when we choose the sorted input for aggregator transformation?

1008

How to update source definition?

1077

What is workflow monitor?

1045

which one is better performance wise joiner or look up

1073

What do you mean incremental aggregation?

1055

What is an unconnected transformation?

1067

What is a dimensional model?

964

what is diff b/t sorter t/r and agg have the option sorter property...

2161