Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 4559

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 12304

whatis the default data driven operation in informatica

2 4675

How to generate a single mapping for both the historical and incremental load.

CSC, TATA,

2 6058

How to eliminate 1st and last rows from the source and load the inbetween rows.

Syntel,

5 18737

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 3856

What are the uses of a Parameter file?

CSC,

3 10666

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 4961

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 4881

List the transformation in informatica.

TCS,

1 10790

where does the default group roew in a router is stored what is the default size of memory in router

1 3424

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 4589

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

Deloitte, TCS,

2 11394

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

Deloitte,

3 17680

What is the difference between IN and Exists in Oracle?

Deloitte,

3 11965


Post New Informatica Questions






Un-Answered Questions { Informatica }

Explain what are the different types of transformation available in informatica.

175


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

823


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

970


What is parallel processing in informatica?

178


Explain what are the different versions of informatica?

182






Explain the informatica workflow?

178


without table how to come first record only in oracle?

1423


How can we use mapping variables in informatica?

174


What is data movement mode in Informatica and difference between them?

220


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

4589


How can we use mapping variables in informatica? Where do we use them?

173


How we can use union transformation?

195


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

1335


How to extract sap data using informatica?

212


Explain pushdown optimization $pushdownconfig parameter - informatica

223