Informatica Interview Questions
Questions Answers Views Company eMail

what we require for D.modelling?

1 3776

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

CTS, Symphony,

6 15499

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

CTS,

1 8243

what is filelist concept in informatica

4 18385

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 8307

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 21958

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

Mastek,

6 9423

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 5433

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 5786

i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 6086

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

Wipro,

3 7829

All active transformations r passive or not?

7 9811

how to load only the first and last record of a flat file into the target?

CTS,

8 27842

What is checksum termnology in informatica? Where do you use it ?

Chase, Cognizant, Deloitte,

3 26745

What is the term PIPELINE in informatica ?

Deloitte,

7 31747


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a pre-defined event and user-defined event?

581


What is rank transformation in informatica

693


Could you explain what is enterprise data warehouse?

559


what is the -ve test case in your project.

1855


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1338






What are the limitations of joiner transformation?

657


How many ways are there to create ports?

731


How would you copy the content of one repository to another repository?

561


Explain about cumulative Sum or moving sum?

624


What is domain in terms of informatica?

567


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


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

535


What are the different components of powercenter?

586


tell me about your project functionality

1870


What do you mean incremental aggregation?

626