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
- 9206 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of transformation?
How might you approve all mappings in the archive all the while?
How can repository reports be accessed without sql or other transformations?
What is informatica? Why do we need it?
What is lookup change?
Define mapping and session?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the types of caches in lookup?
What is a difference between complete, stop and abort?
What is the difference between informatica 7.0 and 8.0?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to implement security measures using repository manager?
Write the unconnected lookup syntax?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is transformation?
