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
- 4910 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / zer0
As far a i understood ur scenario u need each attachment
with its ID and name.
For this you can have a simple mapping made in Informatica.
SQ ----> Expression ----> Target
In Expression create the following:
Input/Output Port: ID
Input/Output Port: Name
Variable Port: Attachments_var1 ---> CHR(32) || TO_CHAR(ID)
|| CHR(9) || Name || CHR(9)
Variable Port: Attachments_var2 ----> REPLACESTR
(0,Attachments,CHR(32),CHR(10) || Attachments_var1)
Output Port: Attachments_out -----> REPLACECHR
(0,Attachments_var2,CHR(32),'')
From expression output the fields to target (Flat File),
you might get your answer
Note: the first record has a space in the attachment name,
that needs to be looked into
| Is This Answer Correct ? | 0 Yes | 2 No |
what is shortcut in informatica? difference between shortcut,reusable object?
in realtime which situations u can use unconnected lookup transformation
In informatica workflow manager, how many repositories can be created?
What is the sql query overwrite in source qualifier in informatica
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
 Informatica Checkpoints
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
can we use self join in informaitca?
Why update strategy and union transformations are active?
how did u understand business requirement?
what is mapping override?
Teradata 
