Informatica Interview Questions
Questions Answers Views Company eMail

what we require for D.modelling?

1 3690

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 15365

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

CTS,

1 8193

what is filelist concept in informatica

4 18304

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 8206

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 21788

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 9308

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

2 5374

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 5720

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 6011

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 7759

All active transformations r passive or not?

7 9729

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

CTS,

8 27651

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

Chase, Cognizant, Deloitte,

3 26601

What is the term PIPELINE in informatica ?

Deloitte,

7 31590


Post New Informatica Questions

Un-Answered Questions { Informatica }

what is degenerated dimension?

3126


How to delete duplicate row using informatica?

579


How many number of sessions can one group in batches?

669


What is joiner transformation in informatica?

600


differences between service based and product based?

1546






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?

1582


What is informatica worklet?

574


How to generate sequence numbers without using the sequence generator transformation?

621


Differences between connected and unconnected lookup?

585


What is Index Caches size?

595


What is informatica etl tool?

530


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1180


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

667


What is persistent lookup cache?

576


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2404