What are the components of Informatica? And what is the purpose of each?

608

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1310

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.

1834

Explain the different kinds of facts.

554

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1548

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1524

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1743

Explain the pipeline partition with real time example?

644

what is the complex transformation you used in informatica

2183

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1727

How do you promote a non-reusable transformation to reusable transformation?

655

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1623

list out all the transformations which use cache?

676

How to create Target definition for flat files?

744

How to load a Dimension ? and how to load a fact table?

944