Which type or t/s is used to convert rows into column &
column into rows
Answer Posted / sowjanya
Using BODS 3.2 or higher versions
To convert columns to Rows : PIVOT transform
To convert rows to coulums : REVERSE PIVOT transform
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is full load & incremental or refresh load?
can be used COM component in Informatica ?
Define slowly changing dimensions (SCD)?
how many steps are there in etl process?
Explain what is etl process? How many steps etl contains explain with example?
What are dimensions?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
Which transformation we use to convert 'NA' to 'Not Available'
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What are the names of the layers in etl?
What is tracing level? How many types of transformations supported by sorted input?
What are the various tools used in etl?
how do u extract data from different data sources explain with an example?
Explain about enterprise scalability and roi of data integration suite?
where is the cache (lookup, index) created and how can you see it.