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
- 7249 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dbloc
Based on the data structure, there are 3 rows present. The
clear indicator here is that the last character of each row
does not have a comma.
A sorter (as previously answered will not handle this using
it's DISTINCT option because each row is distinct. The
previous Normalizer answer just baffles me.
Simple answer: Connect to an expression and only connect
the first port of the record to the target.
a
b
c
Keep it simple.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
Answer / rajesh
use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / amedela chandra sekhar
By using sorter t/r select distinct option
it eliminate the duplicates.
| Is This Answer Correct ? | 0 Yes | 8 No |
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
Explain lookup transformation in informatica
What is aggregator transformation in informatica?
what is the architecture of any Data warehousing project?
How can you generate reports in informatica?
How many cubes create from a single model?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
Teradata 
