Answer / 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

Answer / krishna

You can achieve through Normalizer t/f

Answer / vijay

by using normaliser ransformation only you can convert the
rows to columns and vice versa

Answer / ramarao

Hi Friends,

I think this possible by using source Qualifier ALSO.

The Senario is

Issue_id,Question,Answer
100,1,y
100,2,n
100,3,y
100,4,n

Target is issue_id,Answer1,Answer2,Answer3,Answer4
100, y,n,y,n

This can be Achived by using source Qualifier And joiners.
There is no need to use Normaliser.

Answer / sowjanya

Using BODS 3.2 or higher versions

To convert columns to Rows : PIVOT transform

To convert rows to coulums : REVERSE PIVOT transform

Answer / murugan

By using normalizer transformation we can use the conditions
only applied for row by columns..

by using the normalizer output we can use the function (first)
and then applied for conditions ..and then output will be
seen in column by rows....

Answer / mural

hi ramarao plz explain step by step
i am gettikng confusion

Answer / pradeep sharma

this is easily achievable in talend also using the normalize and textract delimited field

Answer / kumar

i think we have to use macro function in build stage so we
have to write logic in macros but m not sure

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

0 Answers  

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers   CTS,

what is the meaning of upgradation of Repository?

0 Answers   IBM,

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  

Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  

what are the concerns of OLTP and DSS systems?

0 Answers  

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,

what is an ETL or ETT? And what are the different types?

0 Answers  

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

0 Answers  

what are Lookup caches options? Including persistent caches.

1 Answers  

Difference between flat files and relational sources?

0 Answers   Satyam,