source is a flat file
empname, empno, sal
ram, 101, 1,000
sam, 102, 2,000
ques: my target needs the data to be loaded as sal -1000 and
2000 excluding commas
target
empname, empno, sal
ram, 101, 1000
sam, 102, 2000
how to implement this?
Answer Posted / ramkrishna
open the original source flat file then from edit menu
select replace then enter values as find(,000) and replace
with (000)
then save the source file with other name then continue the
process as the flatfile
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is pmcmd command?
what are factless facts? And in which scenario will you use such kinds of fact tables.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the different types of repositories created using informatica?
Explain direct and indirect flat file loading (source file type) - informatica
What are the new features of informatica 9.x in developer level?
What are the different versions of informatica?
What does reusable transformation mean?
How do you load only null records into target? Explain through mapping flow.
Define sessions in informatica etl?
what is INFORMATICA TESTING process
What is a pre-defined event and user-defined event?
Explain the scenario which compels informatica server to reject files?
How to Create a folder using pmrep command?
Explain lookup transformation in informatica