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?
1755How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
1835A 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?
1449
What are the types of Data Warehouse applications?
What is tracing level? How many types of transformations supported by sorted input?
how would u estimate the size of Lookup transform data and index cache?
How many types of transformations supported by sorted input?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are the differences between sql override and update override?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is pmrep command?
What are the etl testing operations includes?
What is etl process?
how many steps are there in etl process?
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 is the difference steps for data modeling?
What is meant by incremental load?