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
- 5060 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 difference between mapping and mapplet ?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
Is it possible to use a client with different version than that of its Informatica server?
What are the types of groups in Router transformation?
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
I have source like this 1:2;3. so i want to load the target as 123
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
What are the two modes of datamovement in informatica sever?
what is the difference between Informatica 7.1 and Abinitio?
what are factless facts? And in which scenario will you use such kinds of fact tables.
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
Teradata 
