Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
1634how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
5 14516can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
1 3431
what is dynamic insert?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how does the server recongnise the source and target databases.Elaborate on this
what are the types in error loging?
What is initial load and what is full load?
What is cube grouping?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What is fact? What are the types of facts?
how would u estimate the size of Lookup transform data and index cache?
What is a staging area? What is the purpose of a staging area?
how do u really know that paging to disk is happening while u are using a lookup transform?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what are the production issues in datastage?
What is etl tool in hadoop?
Can we create Hierarchies in generic datasources?