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

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,


WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,


In Datastage, how you can fix the truncated data error?

0 Answers  


hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,


What is ds designer?

0 Answers  






Define oconv () and iconv () functions in datastage?

0 Answers  


What a datastage macro?

0 Answers  


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,


How one source columns or rows to be loaded in to two different tables?

0 Answers  


i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,


Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  


Categories