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
- 9210 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / varun s
OPEN THE SOURCE FILE-->EDIT-->REPLACE ALL , to NULL.
USE FIXED WITH LENGTH WHILE IMPORTING TO SOURCE AND .....
HOPE IT WILL HELP
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Enlist few areas or real-time situations where informatica is required.
in reporting we add some new objects,how we get the count of the newly added objects to the report
In informatica workflow manager, how many repositories can be created?
what is SDLC way of code development?
What is meant by incremental aggregation?
What is meant by LDAP users?
What are the features of complex mapping?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is data caches/ index caches?
What are the types of caches in lookup? Explain them.
What is meant by query override?
How can one identify whether mapping is correct or not without connecting session?
generate date / time dimension in informatica
Where is metadata stored?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
