1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

Useful UNIX commands regular/frequently used

Deloitte,

1 3631

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

 1 1845

Why the workflow is failed after running two hours in informatica?

GE,

1 2141

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

Cap Gemini,

998

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

Cap Gemini,

1842

How to load a Dimension ? and how to load a fact table?

 957

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

Wipro,

1 1680

Target increases every day even though no new record was inserted

Accenture,

1110

Which is the best place to learn Informatica Powercenter Online Training?

 1 1313

Can we get 1st record through Informatica(without sequence number).

 990

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)

Saama Tech,

1088

Using Connected or unconnected lookup for performance wise which one is preferable?.

Deloitte,

1 1924

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

HCL,

1055

On which transformations you created partitions in your project?

Cap Gemini,

763

can anyone suggest best free Talend data integration training online

 1263

Post New Informatica Questions

Un-Answered Questions { Informatica }

where to store informatica rejected data?

682

What is status code in informatica?

588

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5261

What are the data movement modes in informatica?

705

What is an aggregator transformation?

617




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

635

What is informatica?

684

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?

794

What all join we can perform in LOOKUP transformation?

569

Make a note of the quantity vaults made in informatica?

561

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2299

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1466

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

626

How to update source definition?

634

What could be the possible resons of locks by user?

665

For More Un-Answered { Informatica } Questions Click Here