Informatica interview questions – page 4

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

In bankingdomain projects how many dimension tables are there?

My source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

If i have records like these(source table)rowid name10001 gdgfj10002 dkdfh10003 fjfgdhgjk10001 gfhgdgh10002 hjkdghkfhthe target table should be like these by using expression tranformation.(Target table)rowid name10001 gdgfj10002 dkdfh10003 fjfgdhgjkxx001 gfhgdghxx002 hjkdghkfh(that means duplicated records should contain XX in there rowid)

In SCD type 2 if we had select date range.then suppose we had inserted today's date(eq. date is 30 aug2010) then start date will be today's date(30 aug 2010)what will be the end date,we cant leave it blank?

Can we use unconnected lookup as dynamic lookup?

How can you load data into target table without leading zeor's

There are 4 flat files with number of records as indicatedbelow. Which files should be picked first for joining usingjoiners so as to get best performance.File A - 1000 recordsFile B - 100 recordsFile c - 10000 recordsFile D - 10 records

How we can get unique records into one target table andduplicate records into another target table?

If we have 1000 rows were loaded in to datawarehouse andnext day the source have 1010 rows so, how can we loadedonly updated rows into target.

Which one is better performance wise connected/un-connected lkp?why?

What is the difference between lookup override and souce qualifier override ?

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

How to add source flat file header into target file?

1,If there are 3 workflows are running and if 1st workflowfails then how could we start 2nd workflow or if 2ndworkflow fails how could we start 3rd workflow?

Can session assigned multiple mappings or not?

Suppose we have 1 to 10 records.In router transformation wehad given two conditionA>= 5A<=5then what will be the output?

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions?or In which case u use Unconnected lookup?

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

What is a surrogate key? Why we use it in a mapping? Pl give an example.

What is the need of session partitioning... how it is useful in real time

How to load source and targets in mapping level?

My table contain duplicate Records i wanna load uniq recordsto my table . i have to pass the uniq records throughfilter t/r how?

What are your source in project and how you import in informatica? How can i explain abt this?

WHAT IS FACT LESS FACT TABLE?

If i am having 10 records in source, i want 20 records in target...how will you do it

Tell me some dimension tables names in banking domaininformatica project(dont tell like depends on project, tellme names of dimension and fact table names in your project)?

From where you extract the data, how you did it into informatica? explain...

What is version control in informatica ? Advance thanks

For informatica developer, in real time, normally how much we use sql and plsql?