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 / magnil
how would it be possible if value is other than ,000?
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the differences between source qualifier and joiner transformation?
what is index?how it can work in informatica
Explain transaction control transformation in informatica
Explain sql transformation in script mode examples in informatica
What is a mapplet/worklet in informatica?
What is decode in informatica?
Describe data concatenation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What do you mean by channel change?
What is the difference between a repository server and a powerhouse?
What does refresh system mean, and what are its distinctive choice?
Why union transformation is an active transformation?
Can we create a Integration service without a Repository service and vice versa?
Explain scd type 3 through mapping.