Answer Posted / vijay kumar
domains
nodes
services
| Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
What are the names of the layers in etl?
What is etl process? How many steps etl contains?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
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?
Explain what are the various etl tools in the market?
What are the different etl testing categories as per their function?
How many steps etl contains explain with example?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
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
What is partitioning? Explain about round-robin, hash partitioning.
Explain about hash partitioning?
What is virtual Data Warehousing?
When do we analyze the tables?
What are the differences between sql override and update override?
What is tracing level and what are the types?