Informatica MCQs Set: 9

Informatica MCQs Set: 9

Informatica free practice questions lets you to boost your confidence on nuances of informatica techonology.A great place for you to enhance your knowledge.

Most Frequently asked Informatica Interview Questions and Answers: This article is covering the top Informatica MDM, PowerCenter, Workflow Manager, Workflow Monitor, Designer etc.

1. what are not the piorts of source table.

ans:- i/p port,variable port,sorted port==== (i/p and o/p)

2. informatica is:-

ans:- ETL

3.datawarehousing is

ans:- OLAP

4.some ques like that-----on grouping --for emp id or name

ans :--------look up transform

5.diff between informatica 5.1 and 6.1

ans:-transaction control and sorter

6.what happens when cache of lookup overflows

ans:-----remaining data is written to cache files

7.

longer time duration is given for commit & log datafiles full,what happens to session

ans-----session fails

8.what operation s performed using control task

ans----stop ,abort and fails workflow

9.slowly changing dimension related question (if check box mark on manage data,manage/merge session and manage data)

ansssss------------if radio button mark on manage/merge data

10.if many matches are present in the look up transformation

ans:-for static cache------first and last matching rows returned and error

for dynamic cache ----------the session fails

11.designer performs

ans:-----create mapping

12.where cache(index and data) is stored

ans---------cache directory

13.if stored procedure transformation is after jpiner transformation the target table is imported

ans:-----detail table

14.active transformation related ques

ans:----aggregator trans

15:--repository manager is capable of performing

ans:----manage privieleges,manage groups,manage repository

16.stored proce transformation  checks for target table& disk space of target

ans:---- preload target

17. default join between tables

ans:- normal join

18.sorter trans default cache size

ans:-----8000000 bytes

19.performance can be imp by sorted input in which transformation

ans:----- aggregator

20.if u can sorted i/p ________ it takes some time

ans:------data driven