can we override a native sql query within informatica? Where do we do it?

616

Why do we need informatica?

546

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1069

What is a filter transformation?

555

What are pre and post-session shell commands?

724

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

1724

Explain the different dimensions.

544

Differentiate between joiner and lookup transformation?

603

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

1306

What are the types of lookup transformation?

624

Design a mapping to load the cumulative sum of salaries of employees into target table?

885

What is the maplet?

609

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,

6742

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

776

Mention some types of transformation?

597