how would u estimate the size of Lookup transform data and
index cache?
Identifying the bottlenecks in various components of Informatica and resolving them.
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
What are various etl tools in the market?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
Can anyone explain me a scenario from banking and finance...more precisely a mapping
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,
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 snapshots? What are materialized views & where do we use them? What is a materialized view log?
Two default user groups created in the repository are____and_____.
what is pmrep command?
How can we use external procedural logic in informatica?
What is a mapping, session, worklet, workflow, mapplet?