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
- 9198 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is joiner transformation?
Could you explain what is enterprise data warehouse?
What are the static cache and dynamic cache in informatica?
What is the meaning of up gradation of repository?
What is the format of informatica objects in a repository?
Differentiate between reusable transformation and mapplet.
Explain sql transformation in script mode examples in informatica
How to go to the older version for a mapping?
what is the Default Source Option For Update Strategy Transformation?
What is the difference between router and filter?
How to use procedural logic inside infromatica?
How to call shell scripts from informatica?
How can you validate all mappings in the repository simultaneously?
