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
- 9140 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 do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
what is a transforamation?
What are the options in the target session of update strategy transsformatioin?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What is the target load order?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
how we can update a target table without update strategy and update override?
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
What is router transformation
Teradata 
