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
- 9132 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
Use the replace function in expression and replace',' as null
REPLACE(1,sal,',null)..
It should work
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / hardik
We can simple concatenate 3rd and 4th Row i.e 1 and 000 and
put that concatenated output port in target.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
Answer / magnil
how would it be possible if value is other than ,000?
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / 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 |
what is session override?
Define error Threshold?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
Can we make worklet inside worklet?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
how to join two flat files in informatica?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
How an expression transformation differs from aggregator transformation?
if i have a delimited file as source so how can we seperate this file into three diff targets?
what is materialized view?
Is stop and abort are same in informatica?
Teradata 
