Part1[1-7] Part2[8-14] Part3[15-23] Part4[24-30] Part5[31-37] Part6[38-44]
Part7[45-51]
15. What are the differences between varchar and varchar2?
Ans - They are both variable length data types. Varchar datatype has a size of 2000 bytes and varchar2 has a size of 4000 bytes. varchar is in ascii format while varchar2 is in unicode format
Part7[45-51]
15. What are the differences between varchar and varchar2?
Ans - They are both variable length data types. Varchar datatype has a size of 2000 bytes and varchar2 has a size of 4000 bytes. varchar is in ascii format while varchar2 is in unicode format
16. How can repository reports be accessed without SQL or other transformations?
Ans: There is no need of SQL or other transformation since it is a web app. Repository reports are established by metadata reporter.
17. What is the difference between global index and local index?
Ans - Global index is a single index covering all partitions and local index has separate index for each partition.
Ans - Global index is a single index covering all partitions and local index has separate index for each partition.
18.What is Rank transformation?
Ans - Rank transformation is an Active and Connected transformation. It is used to select the top or bottom rank of data.
19.What are Normaliser transformation?
Ans - Normaliser Transformation is an Active and Connected transformation. It is used with COBOL sources where most of the time data is stored in denormalised format. It can be used to create multiple rows from a single row of data.
21.What are the features of complex mapping?
Ans - Difficult requirements,Many numbers of transformations,Complex business logic
Ans - Difficult requirements,Many numbers of transformations,Complex business logic
22.What is Session?
Ans - A session is a group of commands that describes the server to move data to the target.
Ans - A session is a group of commands that describes the server to move data to the target.
23. What is a Batch?
Batch: A Batch is group of tasks that includes one or more number of tasks.
Part1[1-7] Part2[8-14] Part3[15-23] Part4[24-30] Part5[31-37] Part6[38-44]
Part7[45-51]
Part1[1-7] Part2[8-14] Part3[15-23] Part4[24-30] Part5[31-37] Part6[38-44]
Part7[45-51]
No comments:
Post a Comment