Informatica interview questions and answers part 3

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

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.

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

22.What is Session?
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]