Explain etl mapping sheets?
Answer / Bharat Babu Agrawal
ETL Mapping Sheets are visual representations of how data should be transformed during the ETL process. They contain relationships between source and target systems, as well as specific rules for transformations.
| Is This Answer Correct ? | 0 Yes | 0 No |
how would u estimate the size of Aggregator transform data and index cache?
where is the cache (lookup, index) created and how can you see it.
What are your responsibilities as an etl tester?
What is partitioning? Explain different types of partitioning?
what happens if the info.server doesn't find the session parameter in the parameter file?
what is an ETL or ETT? And what are the different types?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what are the production issues in datastage?
what is data modeling?
where we cannot use sorter Transformation. if we use then we will not get correct data?
How many steps etl contains explain with example?