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?
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 |
What is target load order?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
Can yoU use the maping parameters or variables created in one maping into another maping?
How to get EVEN & ODD numbers separately?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
What is the scenario which compels informatica server to reject files?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
can we override a native sql query within informatica? Where do we do it? How do we do it?
State the differences between sql override and lookup override?
Differentiate between router and filter transformation?