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
- 7098 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
By using sorter t/r select distinct option
it eliminate the duplicates.
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
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 .
Design a mapping to load a target table with the following values from the above source?
Describe the impact of several join conditions and join order in a joiner transformation?
What is the function of look up transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Define pmcmd command?
What is substr in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is olap (on-line analytical processing?
What is decode in informatica?
What differs when we choose the sorted input for aggregator transformation?
Separate from a database, an information bazaar, and an information stockroom?
Where are the source flat files kept before running the session?
What is rank index in rank transformation?
What do you understand by a term domain?
