Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 9383 Views
- Polaris, I also Faced
- E-Mail Answers
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 happens to map if we alter the datatypes between source and its corresponding source qualifier?
scenario where i can use only concurrent execution of workflow.
Can we create two repositories on same database instance in oracle?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How many types of sessions are there in informatica.please explain them?
How can you generate reports in informatica?
Explain in detail scd type 2 through mapping.
How many ways are there to do 'remove duplicate records in informatica'?
How we can create indexes after completing the load process?
How do you load only null records into target?
Can we create multiple integration service on single repository?
Parameter and variable differences
Where can we find the throughput option in informatica?
Explain pmcmd command usage in informatica
What are the types of data warehouses?
