What is the main difference between peek stage and copy
stage
Answers were Sorted based on User's Feedback
Answer / k ramesh reddy
peek stage prints record column values to the job log which
can be viewed in director. it can have a single input link
and multiple output links.
copy stage copies input data( a single stream) to one or
more output data flows.
| Is This Answer Correct ? | 4 Yes | 1 No |
In datastage both peek and copy stages are called stub stages.
Copy stage allows us to copy the input records into multiple o/p links, includes file stages or processing stages.
peek stage is one of the debug stage, which allows us to view
the sample no of records in log or to output file, but not to
any other processing stages.
| Is This Answer Correct ? | 0 Yes | 2 No |
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
where is the cache (lookup, index) created and how can you see it.
What is etl process. How many steps etl contains explain with example?
What are cubes and olap cubes?
What is tracing level? How many types of transformations supported by sorted input?
how do u implement scheduling in Informatica?
what are the concerns of OLTP and DSS systems?
how would u estimate the size of Lookup transform data and index cache?
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
if u can't find what you are looking for in lookup table, how do you handle?
what is granularity in Data ware House?
what is the difference steps for data modeling?