how do u estimate the depth of the session scheduling queue?
Where do u set the number of maximum concurrent sessions
that Informatica can run at a given time?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

What is virtual Data Warehousing?

0 Answers  


what are the concerns of OLTP and DSS systems?

0 Answers  


What are the three tiers in etl?

0 Answers  


What is the main difference between peek stage and copy stage

2 Answers  


I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

2 Answers   Accenture, Saama Tech, TCS,






Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


how do u really know that paging to disk is happening while u are using a lookup transform?

0 Answers  


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

0 Answers  


What is etl process. How many steps etl contains explain with example?

0 Answers  


we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 Answers  


Categories