Interested to Buy Any Domain ? << Click Here >> for more details...
source
file name xyz
a,0,a,a,a
b,b,b,0,b
c,c,c,0,c
target should be like this
xyz
a
b
c
how to implement this?
- 4 Answers
- 7205 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / dilip ingole
don't specify delimiter while importing file and use similar function in informticw as
SELECT substr(REGEXP_REPLACE('a,0,a,a,a','[^[:alpha:]]',''),1,1) FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a pre-defined event and user-defined event?
How do you take back up of repository?
what are the Methods For Creating Reusable Transformations?
What is Data Caches size?
whats the logic to load the lower level of granularity of data to fact table.
What is a rank transform?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
what is diff b/t sorter t/r and agg have the option sorter property...
Does an informatica transformation support only aggregate expressions?
lookup transformation with screenshots
how to load dimension table and fact table. plz tell me the steps.
How to join three sources using joiner? Explain though mapping flow.
How many ways are there to create ports?
What is a connected transformation?
