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 / 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
What is the procedure for creating independent data marts from informatica 7.1?
What is Index Caches size?
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 do you mean by worklet?
without table how to come first record only in oracle?
What is a shortcut and copy in Informatica and how two are different with each other?
Write the program through which the records can be updated?
What does cheating measurement mean?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Define mapplet?
Mention few power centre client applications with their basic purpose?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How do you update the records with or without using update strategy?
Define joiner transformation?
Enterprise data warehouse your projects phase by phase explain?