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
- 4955 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
wf dont have integration severances how you can run?
What is dimensional table? Explain the different dimensions.
What are the different lookup cache(s)?
What are the types of data warehouses?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How does the aggregator transformation handle null values?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to do unit testing in informatica? How to load data in informatica ?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Briefly explain the aggregator transformation?
can you please explain me pre session and post session options?
What you know about transaction control transformation?
What is meant by active and passive transformation?
How can you increase the performance in joiner transformation?
