Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 8450

what is the architecture of any Data warehousing project?

IBM,

5 12727

what is the flow?

1 4423




How to load time dimension?

Ford,

1 10833

In update strategy target table or flat file which gives more performance ? why?

7 16402

How do you create single lookup transformation using multiple tables?

TCS,

6 28259

Why touse stored procedure in ETL Application?

2 7243

How to improve the performance of Aggregate transformation?

Dmss,

3 8685




What is critical mapping?

2 6775

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 13736

How to view and Generate Metadata Reports?

1 4497

what is difference between COM & DCOM?

Satyam,

1 8000

what is the gap analysis?

1 6143

How to recover sessions in concurrent batches?

3 10507

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 18648


Post New Informatica Questions






Un-Answered Questions { Informatica }

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

5663


tell me the rules and responsblites in our project(my project is development)

641


In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1406


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1131


According to his methodology what all you need before you build a datawarehouse

455






Is there any target staging area in informatica not staging area

1310


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1148


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

734


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

916


What is confirmed fact in dataware housing?

4027


what are the deliverables?in your project?

851


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1141


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

848


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1038


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

67