my source is a comma delimited flatfile as
eno, ename, sal
111,sri,ram,kumar,1000
and my target should be
eno ename sal
111 sri ram kumar 1000
i.e; we need to eliminate the commas in between the data of a comma delimited file.
- 5 Answers
- 8260 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ahalya inturi
Go to the session properties.In that go to connections in that select the source name there you will find "Set file Properties" button. There you can set the delimeter.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is Index Caches size?
How do you take back up of repository?
Explain what transformation and how many are there in informatica?
To import the flat file definition into the designer where should the flat file be placed?
State the limitations where we cannot use joiner in the mapping pipeline?
What is union transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What is the difference between router and filter?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is decode in informatica?
Design a mapping to load a target table with the following values from the above source?
How do you load only null records into target? Explain through mapping flow.
What is domain in terms of informatica?
Explain how to import oracle sequence into informatica?
