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?
Answer Posted / dilip ingole
don't specify delimiter while importing file and use similar function in informticw as
SELECT substr(REGEXP_REPLACE('a,0,a,a,a','[^[:alpha:]]',''),1,1) FROM DUAL;
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
lookup transformation with screenshots
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can u generate reports in Informatica?
Write the unconnected lookup syntax and how to return more than one column.
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to update source definition?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How to create the source and target database connections in server manager?
which one is better performance wise joiner or look up
What is repository manager?
What is the cumulative sum and moving sum?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
can you please explain me pre session and post session options?
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?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?