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
- 9128 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 do think which one is the better joiner or look up?
what is SDLC way of code development?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Describe an informatica powercenter?
What is joiner transformation?
What is the maplet?
During the running session, output files are created by informatica server. Enlist few of them.
What are the restrictions of union transformation?
What are the measure objects?
What is an expression transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
differences between service based and product based?
What are the components of the workflow manager?
What is sequence generator transformation in informatica?
Define filter transformation?
