Informatica interview questions

[...] Informatica Interview Questions and Answers Set 1 Q1: Define the term data warehouse. A1: As per Bill Inmon, widely [...]

[...] Informatica Interview Questions and Answers Set 4 Q31: Which files are created during the session runs by Informatica [...]

[...] Informatica Interview Questions and Answers Set 2 Q11: Explain Operational data store. A11: Operational Data Store is [...]

[...] . Rows not meeting the conditions are categorized separately. Popular Tags : Informatica Interview Questions [...]

[...] 2000. E.g. varchar2(4000) goes above 4000, Informatica makes it as varchar2(2000). Q50: In Informatica server what different modes are available for data processing? A50: In Informatica server data [...]

[...] the various dimensions of Informatica. A13: The three types of dimensions of Informatica server are: a)      Conformed dimension, b)      Degenerative dimension, c)      Junk [...]

[...] which have access to RDBMS based datasets are called lookup transformations. The Informatica server quickens access by using the look up tables to point at specific table data or views from [...]

[...] Questions and Answers Set 4 Q31: Which files are created during the session runs by Informatica server? A31: The following four files are created by the Informatica server during session runs: a) [...]

[...] . Q25: Explain Joiner transformation. A25: Joiner transformation is a connected and active transformation. It is used for joining two different sources originating from same or different locations. [...]

[...] Source Qualifier Transformation. A42: Source Qualifier Transformation is a connected and active transformation. It is used while adding a relational source definition to a maping. It performs tasks [...]

[...] informatica powercenter interview questions and Answers Set 7 Q61: Explain Enterprise Data Warehousing. A61: Enterprise Data Warehousing means creating a [...]

[...] Informatica Job Interview Questions and Answers Set 6 Q51: What do you mean by code page compatibility? A51: Code page compatibility is a [...]

[...] Informatica Interview Questions and Answers Set 4 Q31: Which files are created during the session runs by Informatica server? A31: The [...]

[...] Informatica Interview Questions and Answers Set 2 Q11: Explain Operational data store. A11: Operational Data Store is the second layer of data [...]

[...] checks for many conditions. Rows not meeting the conditions are categorized separately. Popular Tags : Informatica Interview Questions [...]

[...] can be called in another transformation to return a value for that transformation. Popular Tags : Informatica Interview Questions [...]

[...] from various views and preparing a summary providing useful information is called data mining. Popular Tags : Informatica Interview Questions [...]

[...] of the lookup conditions and return port. It doesn’t support default user defined values. Popular Tags : Informatica Interview Questions [...]

Informatica Interview Questions and Answers Set 4 Q31: Which files are created during the session runs by Informatica server? A31: The following fou [...]

Informatica Interview Questions and Answers Set 2 Q11: Explain Operational data store. A11: Operational Data Store is the second layer of data wareh [...]

Informatica Interview Questions and Answers Set 3 Q21: List the various types of transformations in Informatica. A21: The various types of transform [...]

[...] different sources originating from same or different locations. Q26: Explain the use of lookup transformations. A26: Lookup transformations are used for accessing data from relational tables. These [...]

[...] . A56: Transformations which have access to RDBMS based datasets are called lookup transformations. The Informatica server quickens access by using the look up tables to point at [...]

[...] various types of data models like: a)      Conceptual data modeling, b)      Dimensional data modeling, c)      Relation data modeling, d)     Enterprise data modeling, e) [...]

[...] : In Informatica server what different modes are available for data processing? A50: In Informatica server data processing and movement is managed by either Unicode or ASCII (1 byte format) modes. [...]