Interested to Buy Any Domain ? << Click Here >> for more details...
I have source like col1,col2,col3,col4 and the values are like
3,6,1,7
1,5,3,8
2,1,5,6
i want the output like
3,6,7
5,3,8
2,5,6
How we will achieve in this scenario in informatica level.
Please help me..
Thanks in advance..
- 4 Answers
- 8657 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vidya
source -- sq -- exp1 -- exp2 -- t
exp1- create 4 var ports, and 1 output port as
v1=iif(col1=1, null, c1)
v2=iif(col2=1, null, c2)
v3=iif(col3=1, null, c3)
v4=iif(col4=1, null, c4)
op_port1=v1||v2||v3||v4
exp2- op_port1
create 3 out_put port
c1=substr(op_port1, 1,1)
c2=substr(op_port1, 2,1)
c3=substr(op_port1, 3,1)
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Separate from an archive server and a powerhouse?
-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?
What is the need for an etl tool?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How can we remove the duplicates from flat file source?
How to improve the performance of a session using sorter transformation?
What is main use of mapplet?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Difference between Data and Index Caches?
Briefly describe lookup transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
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 .
