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?
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
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain sessions and how many types of sessions are there?
Briefly describe lookup transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to go to the older version for a mapping?
What is a surrogate key?
How can repository reports be accessed without sql or other transformations?
How to load the data from people soft hrm to people soft erm using informatica?
what is the size of your data warehousing?
What is a joiner transformation and why it is an active one?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com