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
- 8984 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
What is confirmed fact in dataware housing?
How do you convert single row from source into three rows into target?
What is domain and gateway node?
list out all the transformations which use cache?
How might you approve all mappings in the archive all the while?
What is an unconnected transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Enlist the differences between database and data warehouse.
How can you generate reports in informatica?
What is data caches/ index caches?
What is the use of code page?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the different types of transformation available in informatica.
What is the difference between stop and abort in informatica
Write the prerequisite tasks to achieve the session partition?
