How to delete data which is not in source table?
what is session partitioning?
What are various etl tools in the market?
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
what is the indicator file and where it is used?
working of line item dimension......pls,tell overall flow
what is a worklet?
how do u implement configuration management in Informatica?
what is the difference between OLTP database and data warehousing database?
Which type or t/s is used to convert rows into column & column into rows
Difference between flat files and relational sources?
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 data modeling tools you have used?(polaris)