Explain how to import oracle sequence into informatica?

575

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

617

How you can differentiate between connected lookup and unconnected lookup?

597

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1855

Define filter transformation?

612

What is rank transformation?

562

What are the reusable transformations?

684

How to update a particular record in target with out running whole workflow?

1147

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1822

What is the procedure for creating independent data marts from informatica 7.1?

554

Write the prerequisite tasks to achieve the session partition?

629

What is DR strategy for Informatica project?

683

Explain the different kinds of facts.

551

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

1735

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1318