Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 5058 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
What is a surrogate key?
What are the measure objects?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to convert multiple rows to single row (multiple columns) in informatica
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Differentiate between Load Manager and DTM?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Clarify the utilization of aggregator cache record?
What happens when a session fails and you click on recover?
What are the informatica performance improvement tips
How do you migrate data from one environment to another?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are connected or unconnected transformations?
What is mapping debugger?
