OPEN THE SOURCE FILE-->EDIT-->REPLACE ALL , to NULL. USE FIXED WITH

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?

Question Posted / varun s

5 Answers
9197 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

Please Help Members By Posting Answers For Below Questions

what is the -ve test case in your project.

2407

What is the use of source qualifier?

1138

How to extract sap data using informatica?

1042

What is main use of mapplet?

1132

Which transformation is needed while using the Cobol sources as source definitions?

1174

How do you promote a non-reusable transformation to reusable transformation?

1138

Define filter transformation?

1096

What is a mapplet/worklet in informatica?

1188

Can u generate reports in Informatica?

1087

What are the static cache and dynamic cache in informatica?

1192

can anyone explain me about retail domain project in informatica?

7947

Is stop and abort are same in informatica?

1002

Describe expression transformation?

1126

What is workflow monitor?

1062

Explain the etl program with few examples.

1050