1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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 5560

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 13977

whatis the default data driven operation in informatica

 2 5858

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

CSC, TATA,

2 7189

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

Syntel,

5 24228

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 4564

What are the uses of a Parameter file?

CSC,

3 12012

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 5750

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 5963

List the transformation in informatica.

TCS,

1 11564

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

 1 4186

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 5564

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 14441

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

Deloitte,

3 24351

What is the difference between IN and Exists in Oracle?

Deloitte,

3 14516

Post New Informatica Questions

Un-Answered Questions { Informatica }

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1631

How do we call shell scripts from informatica?

599

Explain pushdown optimization $pushdownconfig parameter - informatica

703

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

630

What is xml source qualifier transformation in informatica?

714




Differences between connected and unconnected lookup?

610

wf dont have integration severances how you can run?

1541

explan ur project architecture?

1599

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1592

What is data transformation manager process?

621

What is meant by LDAP users?

697

Implementation methodology

1262

During the running session, output files are created by informatica server. Enlist few of them.

544

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

5825

Is there any way to read the ms excel datas directly into informatica?

552

For More Un-Answered { Informatica } Questions Click Here