When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
536What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
649In 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?
542
can be used COM component in Informatica ?
when will use SQL override in a lookup transformation?
Explain the key challenges that you face while performing etl testing.
What are the different etl testing categories as per their function?
How many steps etl contains?
Two default user groups created in the repository are____and_____.
what is the difference steps for data modeling?
What is partitioning? Explain about round-robin, hash partitioning.
What do you understand by active and passive transformations?
How can we use external procedural logic in informatica?
What is etl process?
How to delete data which is not in source table?
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?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is different between sequential batch and concurrent batch and which is recommended and why?