Sign Up Login


  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 4007

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

 1 2178

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

GE,

1 2450

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,

1241

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,

2081

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

 1141

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 2070

Target increases every day even though no new record was inserted

Accenture,

1329

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

 1 1651

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

 1197

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,

1335

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

Deloitte,

1 2275

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,

1273

On which transformations you created partitions in your project?

Cap Gemini,

970

can anyone suggest best free Talend data integration training online

 1466

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is rank index in rank transformation?

792

What is expression transformation?

819

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1847

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5983

What are the reusable transformations?

868

What is confirmed fact in dataware housing?

6191

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

3736

what is the complex transformation you used in informatica

2377

What is a grid in Informatica?

822

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

1748

What are roles and groups and benefits of using them?

765

What are the components of the workflow manager?

869

What is sq transformation?

845

How to do the error handling of if ur source is flatfiles?

1705

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3601

For More Un-Answered { Informatica } Questions Click Here