Informatica Interview Questions
Questions Answers Views Company eMail

I have a flat file, want to reverse the contents of the flat file

Informatica,

896

which one is better performance wise joiner or look up

Informatica,

830

write a query to retrieve the latest records from the table sorted by version(scd)

Informatica,

834

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

Informatica,

910

Which transformation is needed while using the Cobol sources as source definitions?

Informatica,

928

What is an unconnected transformation?

Informatica,

855

What is the status code in stored procedure transformation?

Informatica,

890

Explain dynamic target flat file name generation in informatica

Informatica,

836

update strategy transformation in informatica

Informatica,

826

Difference between Data and Index Caches?

Informatica,

865

How many ways are there to create ports?

Informatica,

942

Which means the first record should come as last record and last record should come as first record and load into the target file?

Informatica,

817

What is blocking transformation?

Informatica,

913

Explain the tuning lookup transformation - informatica

Informatica,

782

Explain about Informatica server process that how it works relates to mapping variables?

Informatica,

819


Post New Informatica Questions

Un-Answered Questions { Informatica }

Why union transformation is an active transformation?

852


What are the reusable transformations?

870


Explain sessions. Explain how batches are used to combine executions?

780


what is SDLC way of code development?

1761


State the differences between sql override and lookup override?

853


How might one distinguish in the case of mapping is right or not without associating session?

839


in reporting we add some new objects,how we get the count of the newly added objects to the report

1964


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

910


How to join three sources using joiner?

790


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

771


How does a rank transform differ from aggregator transform functions max and min?

903


Briefly define reusable transformation?

838


Explain pushdown optimization $pushdownconfig parameter - informatica

903


how to load rows into fact table in data warehouse

881


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

791