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
9381 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

Have you worked with/created Parameter file

1710

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1110

What is status code in informatica?

1063

What is a grid in Informatica?

1115

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7175

What is a difference between complete, stop and abort?

1123

What is the maplet?

1200

How do you load only null records into target? Explain through mapping flow.

2072

can we override a native sql query within informatica? Where do we do it? How do we do it?

1108

What is Session and Batches?

1147

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1152

What is an active transformation?

1157

How many ways a relational source definition can be updated and what are they?

1061

What are multi-group transformations?

1161

What is depict expression change?

1189