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

what r the transformations that r not involved in mapplet?

Wipro,

8 29099

what is data driven?

TCS, Wipro,

5 51605

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

 6 7969

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

TCS,

5 23523

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

 3 10566

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

Target,

9 18051

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

TCS,

2 9136

HOW TO GET THE LATEST DATA IN SCD ?

TCS,

4 20128

what is the function of 'F10' informatica ?

IBM,

4 13923

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

TCS,

3 9460

what are the reusable tasks in informatica ?

CTS, HP, IBM, TCS,

11 49910

HOW DO YOU PARFORM INCREMENTAL LAOD ?

SAIC,

7 14432

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

Oracle,

4 11813

HOW DO YOU CONNECT TO REMOTE SERVER ?

Patni, TCS,

1 7763

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

Target,

7 32025

Post New Informatica Questions

Un-Answered Questions { Informatica }

list out all the transformations which use cache?

676

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

624

How many ways are there to do 'remove duplicate records in informatica'?

574

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1021

What do think which one is the better joiner or look up?

709




Partition, what happens if the specified key range is shorter and longer

2023

What is the function of union transformation?

608

What is sorter transformation?

572

tell me the rules and responsblites in our project(my project is development)

1487

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

1737

have u done any performance tuning? how u ll do?

1849

What do you understand by SOA of Informatica?

576

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

1454

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1605

What is the way to execute pl/sql script using informatica mapping?

950

For More Un-Answered { Informatica } Questions Click Here