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 |
How to prepared lld.can any one tell me detailed explanetion.
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
How to enter same record twice in the target table,explain?
What is depict expression change?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
How to import oracle sequence into Informatica?
Differentiate between sessions and batches?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
Why should we use star schema in datawarehouse design?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You