when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
2135How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
2231A 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?
1832
What is data modeling and data mining?
tell me few points when u become TL
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain the use lookup tables and Aggregate tables?
What is cube grouping?
Difference between flat files and relational sources?
can be used COM component in Informatica ?
Explain do we need an etl tool? When do we go for the tools in the market?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What are various etl tools in the market?
Explain different types of partitioning?
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 cubes developed in a sap bw project and what is the requirement for developing it?
What are materialized views & where do we use them?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort