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?
Answer Posted / 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 |
Post New Answer View All Answers
What is Data Caches size?
Enlist the tasks for which source qualifier transformation is used.
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 .
draw informatica architecture 8.6 ?
Please let me know how to make Data masking in informatica..
What are the uses of etl tools?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain about Informatica server process that how it works relates to mapping variables?
Write the program through which the records can be updated?
Enterprise data warehouse your projects phase by phase explain?
What is the reusable transformation?
What all are steps in up gradation of Informatica server?
Clarify the aggregator change?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can you increase the performance in joiner transformation?