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?

1014

EXL informatica Questions

916

Major difference between SQL override and Lookup Sql override

1 2905

What are the reusable transformations?

Informatica,

684

What is the maplet?

Informatica,

602

Explain incremental aggregation in informatica

Informatica,

637

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

Informatica,

627

What is rank transformation in informatica

Informatica,

678

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

Informatica,

674

How to generate sequence numbers using expression transformation?

Informatica,

622

What is Index Caches size?

Informatica,

601

What is Session and Batches?

Informatica,

644

Explian the connected and unconnected lookup transformation

Informatica,

1 857

What is the Rank index port in Rank transformation?

Informatica,

661

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

Informatica,

611


Post New Informatica Questions

Un-Answered Questions { Informatica }

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1620


What all join we can perform in LOOKUP transformation?

546


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

1540


How to elaborate tracing level?

670


How big was your fact table

1301






i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1687


What is incremental aggregation?

562


list out all the transformations which use cache?

672


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3488


What is the use of target designer?

590


What are the popular informatica products?

639


What is meant by lookup transformation? Explain the types of lookup transformation?

551


What is a dimensional model?

568


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

620


What is a router transformation?

611