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 / 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
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
generate date / time dimension in informatica
What does role playing dimension mean?
What is flashback table ? Advance thanks
What is informatica metadata and where is it stored?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the steps involved in the migration from older version to newer version of Informatica Server?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are Dimensional table?
What is the procedure for creating independent data marts from informatica 7.1?
What's the layout of parameter file (what does a parameter file contain?)?
How you can differentiate between connected lookup and unconnected lookup?
What are the new features of informatica 9.x developer?
What is meant by lookup transformation? Explain the types of lookup transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?