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
- 7947 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rakesh
no my question is clear. and my target is oracle table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is primary and backup node?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
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
How do you use reject loader.
What is deployment group?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the difference between a repository server and a powerhouse?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are multi-group transformations?
Explain the different kinds of facts.
What are the differences between joiner transformation and source qualifier transformation?
Can we create a Integration service without a Repository service and vice versa?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
scenario where i can use only concurrent execution of workflow.
How we can use union transformation?
