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.
No Answer is Posted For this Question
Be the First to Post Answer
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
what are the facilities provided by data warehouse to analytical users?
Explain me ETL project architecture in Detail?
what are the production issues in datastage?
What is etl process? How many steps etl contains?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is Relational Integrity?
what are business components in Informatica?
how do u decide whether u need to do aggregations at database level or at Informatica level?
what is the use of server manager?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.