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
- 9221 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 is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the need of an ETL tool?
Explain direct and indirect flat file loading (source file type) - informatica
Enlist the differences between database and data warehouse.
What are data-driven sessions?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What does update strategy mean, and what are the different option of it?
What is the use of an aggregator cache file?
what is size of u r database?
What is the session task and command task?
What are the main issues while working with flat files as source and as targets ?
What is meant by incremental aggregation?
What are the differences between a connected lookup and unconnected lookup?
waht type of interface is used for testing the data in informatica
wat are deployement groups in informatica, how it will be used for developers
