Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?

Answer Posted / guest

Need to connect to the normalizer transformation and ther
put occurs in the normalizer properties

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1136


What are the static cache and dynamic cache in informatica?

720


What is sorter transformation?

586


How big was your fact table

1320


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6093






What is the use of transformation?

576


How to use procedural logic inside infromatica?

638


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

812


Can u generate reports in Informatica?

658


What all join we can perform in LOOKUP transformation?

569


What is data caches/ index caches?

615


Explain the types of transformations?

597


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1741


What is the difference between stop and abort in informatica

666


What is the meaning of decode in informatica?

648