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

What is a parameter When and where do you them when does the value will be created

 1389

Design time, run time. If you don't create parameter what will happen

 1415

What are variable ports and list two situations when they can be used?

 1 2240

What are the parts of Informatica Server?

Cognizant,

1 2597

How does the server recognize the source and target databases. Elaborate on this.

 1 3284

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

 1 2849

What is the difference between sequential batch and concurrent batch and which is recommended and why?

 1 2673

A session S_MAP1 is in Repository A. While running the session error message has displayed

 1 2579

server hot-ws270 is connect to Repository B. What does it mean?

Cognizant,

1843

How do you do error handling in Informatica?

 1 7122

How do you implement scheduling in Informatica?

 1 3022

What is the meaning of up gradation of repository?

 1379

How can you run a session without using server manager?

 1 3509

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

 2 3300

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

 1497

Post New Informatica Questions

Un-Answered Questions { Informatica }

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2418

What is confirmed fact in dataware housing?

5654

What are the new features of informatica 9.x developer?

524

What are the tuning techniques you applied during your last project

1553

How to create Target definition for flat files?

743




How will the document be delivered to me?

609

How can you increase the performance in joiner transformation?

695

How do you load alternate records into different tables through mapping flow?

1280

What are the modules in Power Center

1216

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3436

explain one complex mapping with logic? sales project?

6132

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

1726

How to use pmcmd utility command?

573

What is the difference between informatica 7.0 and 8.0?

558

What is event and what are the tasks related to it?

603

For More Un-Answered { Informatica } Questions Click Here