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
- 9049 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 |
How to handle changing source file counts in a mapping?
why do we go for update strategy tr in SCD rather using the session properties?
in performance wise union is past,union all is past
Router T/R is active but some people are saying it is also passive which is exactly right?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
how can we perform incremental aggregation?explain with example?
How can you increase the performance in joiner transformation?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What are the types of schemas we have in data warehouse.
What is InformaticaPowerCenter?
What are the static cache and dynamic cache in informatica?
What are junk dimensions?
Teradata 
