Answer Posted / dk2bbr
desc tablename;
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Explain etl?
What is etl process? How many steps etl contains?
Can u access a repository created in previous version of Informatica?
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 different between sequential batch and concurrent batch and which is recommended and why?
Difference between flat files and relational sources?
What is cube grouping?
what are the concerns of OLTP and DSS systems?
How etl testing is different from database testing?
What is a mapping?
What is the difference between round-robin partitioning and hash partitioning?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain the difference between etl tool and olap tools?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What are the various tools used in etl?