Informatica Interview Questions
Questions Answers Views Company eMail

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1027

EXL informatica Questions

930

Major difference between SQL override and Lookup Sql override

1 2935

What are the reusable transformations?

Informatica,

695

What is the maplet?

Informatica,

616

Explain incremental aggregation in informatica

Informatica,

650

How to generate sequence numbers without using the sequence generator transformation?

Informatica,

640

What is rank transformation in informatica

Informatica,

687

How to improve the performance of a session using sorter transformation?

Informatica,

686

How to generate sequence numbers using expression transformation?

Informatica,

635

What is Index Caches size?

Informatica,

614

What is Session and Batches?

Informatica,

660

Explian the connected and unconnected lookup transformation

Informatica,

1 878

What is the Rank index port in Rank transformation?

Informatica,

667

What are mapplets? How is it different from a Reusable Transformation?

Informatica,

622


Post New Informatica Questions

Un-Answered Questions { Informatica }

Enlist the tasks for which source qualifier transformation is used.

586


What is the commit type if you have a transaction control transformation in the mapping?

650


Explain how many types of dimensions are available in informatica?

590


Explain the types of lookup transformation?

566


What is an active transformation?

643






How to load data in informatica ?

568


How many types of sessions are there in informatica.please explain them?

675


How many ways a relational source definition can be updated and what are they?

575


Differentiate between router and filter transformation?

610


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

535


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1682


How can repository reports be accessed without sql or other transformations?

721


Why filter transformation is an active one?

561


What is event and what are the tasks related to it?

612


What are mapplets?

814