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
- 30013 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
Define slowly changing dimensions (SCD)?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what do u do when DB time takes more?in sap bi
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
can be used COM component in Informatica ?
where is the cache (lookup, index) created and how can you see it.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What are the three tiers in etl?
What are cubes and olap cubes?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
how do u set partition points in the mapping?
can cubes contain measures ?
How etl testing is different from database testing?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is a mapping, session, worklet, workflow, mapplet?
