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
- 9405 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
Design time, run time. If you don't create parameter what will happen
What is union transformation in informatica?
Can we get 1st record through Informatica(without sequence number).
What is pmcmd command?
What are the types of caches in lookup? Explain them.
Explain sql transformation in script mode examples in informatica
What is incremental aggregation?
What the difference is between a database, a data warehouse and a data mart?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain your project of banking domian.
What do you mean by channel change?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you take back up of repository?
How can you define user defied event?
