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..
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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain how many types of dimensions are available in informatica?
How to update a particular record in target with out running whole workflow?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is fact table? Explain the different kinds of facts.
What is incremental aggregation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the differences between joiner transformation and source qualifier transformation?
can we override a native sql query within informatica? Where do we do it?
Explain incremental aggregation in informatica
What is a pre-defined event and user-defined event?
What are the new features of informatica 9.x at the developer level?