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
- 7052 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What does cheating measurement mean?
Explain dynamic target flat file name generation in informatica
What are the tasks that source qualifier perform?
How can we handle two sessions in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain what are the different types of transformation available in informatica.
Enlist the various types of transformations.
What is olap (on-line analytical processing?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
tell me the rules and responsblites in our project(my project is development)
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the settings that you use to configure the joiner transformation?
I have a flat file, want to reverse the contents of the flat file
What is the session task and command task?
What is the function of union transformation?
