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
- 4827 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is the size of your data warehousing?
How to go to the older version for a mapping?
What is aggregate cache in aggregator transformation?
Parameter and variable differences
What is a passive transformation?
How are the sources and targets definitions imported in informatica designer?
What is the need of etl tools?
What is a dimensional model?
How to implement security measures using repository manager?
On which transformations you created partitions in your project?
COM components can be used in Informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is incremental aggregation?
