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
What is a filter transformation and why it is an active one?
On which transformations you created partitions in your project?
How would you join a node to the already existing domain?
Tell me about Propagate functions in informatica
what is degenerated dimension?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the different lookup cache(s)?
expain about the tune parameters?
What is data movement mode in Informatica and difference between them?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
can you please explain me pre session and post session options?
How are the sources and targets definitions imported in informatica designer?
how tokens will generate?