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
- 9133 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
How can we use mapping variables in informatica?
What are the tasks that can be performed using sq?
Why union transformation is an active transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is native users?
What is informatica powercenter repository?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What all join we can perform in LOOKUP transformation?
Different sorts of metadata that stores in the storage facility?
Performance tuning( what you did in performance tuning)
Tell me about Propagate functions in informatica
What does reusable transformation mean?
What is rank transform?
