Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 16177

What is Factless fact table ???

Satyam, Tech Mahindra,

12 45269

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

CTS, TCS,

8 36928

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 8692

How will u find weather dimension table is big in size of a fact table?

1 7236

How will u pas the data with out debugger?

4 8540

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 15052

I have 1200 records how can u send it in aggregator with good performance issues?

3 9507

what is the logic will you implement to load data into a fact table from n dimension tables?

TCS,

4 19814

Why is meant by direct and indirect loading options in sessions?

4 24203

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 9055

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

TCS,

8 25051

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 13211

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 10027

how do u move the code from development to production?

3 20323

Post New Informatica Questions

Un-Answered Questions { Informatica }

Which files are created during the session rums by informatics server?

1179

how to create user defined function (udf) in informatica

1305

What are the static cache and dynamic cache in informatica?

1192

Explain the features of connected and unconnected lookup.

935

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1628

Where can we find the throughput option in informatica?

1063

How do you convert single row from source into three rows into target?

1157

In how many ways we can create ports?

1123

What are the types of data warehouses?

1526

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2334

Explain lookup transformation is active in informatica

1104

What are mapplets? How is it different from a Reusable Transformation?

1088

How can you differentiate between powercenter and power map?

1088

Did u used latest transformations of 8.6.0? for what?

1882

For More Un-Answered { Informatica } Questions Click Here