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
- 7626 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
difference between repository database and repository service?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a snowflake schema?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the use of an aggregator cache file?
what are the deliverables?in your project?
How to generate sequence numbers?
How many ways a relational source definition can be updated and what are they?
Do you find any difficulty while working with flat files as source and target?
How to elaborate powercenter integration service?
Which development components of informatica have the highest usage?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Differentiate between joiner and lookup transformation?
What is a connected transformation?
