Well make the (id, attachment) as unique or primary key instead of id bei

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

2 Answers
4953 Views
I also Faced
E-Mail Answers

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 are the conditions needed to improve the performance of informatica aggregator transformation?

1094

Describe the impact of several join conditions and join order in a joiner transformation?

1063

What is a dimensional model?

982

Explain the etl program with few examples.

1051

What is an expression transformation in informatica?

1040

How you prepared reports for OLAP?

1597

How does a rank transform differ from aggregator transform functions max and min?

1207

Enlist the differences between database and data warehouse.

1121

How to load last n records of file into target table - informatica

1082

What is dimensional table?

1067

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

Reusable transformation and shortcut differences

1840

What are the tasks that source qualifier perform?

1106

lookup transformation with screenshots

4006

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979