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
- 7611 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
Explain about cumulative Sum or moving sum?
explan ur project architecture?
what is SDLC way of code development?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How do you load only null records into target? Explain through mapping flow.
What are the restrictions of union transformation?
What is rank index in rank transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is target load order?
What is the use of transformation?
what is the complex transformation you used in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Clarify the utilization of aggregator cache record?
In which transformation you cannot drag ports into it?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
