What is Horizontal transformation, vertical
transformation,diagonal transformation?

Answers were Sorted based on User's Feedback



What is Horizontal transformation, vertical transformation,diagonal transformation?..

Answer / bharath

Instead of transformation use Combination in datastage,

Horizontal combining:
> join
> look-up
> merge
Vertical combining:
> remove duplicates
> Aggregation
Diagonal Combining:(not sure)
> vertical pivoting
> Horizontal Pivoting

Is This Answer Correct ?    2 Yes 2 No

What is Horizontal transformation, vertical transformation,diagonal transformation?..

Answer / npr

IS it DWH question ???????

Is This Answer Correct ?    4 Yes 5 No

Post New Answer

More Data Stage Interview Questions

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,


How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  


Highlight the main features of datastage?

0 Answers  


why dataset ?

2 Answers  






hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,


Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,


Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,


1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  


table actions available in oracle connector?

0 Answers   CTS,


How we can convert rows to columns in datastage?

4 Answers   IBM,


How many types of stage?

0 Answers  


Categories