Interested to Buy Any Domain ? << Click Here >> for more details...
Which type or t/s is used to convert rows into column &
column into rows
- 9 Answers
- 29728 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / prakash chandran
Row To columns
--------------
Use Normalizer Transformation
Column To Rows
--------------
SOURCE
------
ENO COL_HDR COL_VAL
------------------------
1 ENAME PRAKASH
1 ESAL 35000
2 ENAME SREE
2 ESAL 25000
OUTPUT
------
ENO ENAME ESAL
1 PRAKASH 35000
2 SREE 25000
MAPPING LOGIC
--------------
SRC -----> AGG -----> TGT
Use First Function in Aggegrator to convert the Column to
rows
In Aggegrator, Create two output columns and write the
following expression
Port Name Expression
--------- ----------
O_ENAME FIRST(COL_VAL,COL_HDR='ENAME')
O_ESAL FIRST(COL_VAL,COL_HDR='ESAL')
Please get back to me in case of queries.
Thx & Regards,
Prakash Chandran
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What is partitioning? Explain different types of partitioning?
where is the cache (lookup, index) created and how can you see it.
Do we need an ETL tool? When do we go for the tools in the market?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are the modules in Power Mart?
Explain me ETL project architecture in Detail?
Can u access a repository created in previous version of Informatica?
dimension object created in oracle can be imported in designer?how?
In Which Transformation We Can Use Having Clause In Informatica?
how would u estimate the size of Lookup transform data and index cache?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is etl process?
what is the use of server?
What is fact? What are the types of facts?
what is pmrep command?
