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
- 9131 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
what is the -ve test case in your project.
What is the scenario which compels informatica server to reject files?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What differs when we choose the sorted input for aggregator transformation?
How are indexes created after completing the load process?
What are session parameters ? How do you set them?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Design a mapping to load a target table with the following values from the above source?
What is the fact table?
What is event and what are the tasks related to it?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain lookup transformation source types in informatica
how we can load rejected record's at run time?(not through bad files)
