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
4927 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 components of Informatica? And what is the purpose of each?

1042

Why update strategy and union transformations are active? Explain with examples.

1227

How do you set a varible in incremental aggregation

1879

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2006

Can u generate reports in Informatica?

1071

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1916

design of staging area?

2024

What are the different transaction levels available in transaction control transformation?

1187

What do you mean incremental aggregation?

1069

What is informatica powercenter repository?

1184

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5661

According to his methodology what all you need before you build a datawarehouse

1748

Can we get 1st record through Informatica(without sequence number).

1470

list out all the transformations which use cache?

1174

What is option by which we can run all the sessions in a batch simultaneously?

1130