Answer Posted / bsgsr
hi,everyone,
HLD means high level design
LLD means low level design
HLD: It refers to the functionlity to be achieved to meet
the client requirement. Precisely speaking it is a
diagramatic representation of clients operational systems,
staging areas, dwh n datamarts. also how n what frequency
the data is extracted n loaded into the target database.
LLD: It is prepared for every mapping along with unit test
plan. It contains the names of source definitions, target
definitions, transformatoins used, column names, data
types, business logic written n source to target field
matrix, session name, mapping name.
reach me on bsgsr12@gmail.com 9866188658
| Is This Answer Correct ? | 116 Yes | 7 No |
Post New Answer View All Answers
Explain the use of aggregator cache file?
What is the status code in stored procedure transformation?
How can a transformation be made reusable?
In which transformation you cannot drag ports into it?
What are the main features of Oracle 8i with context to datawarehouse?
How to partition the Session?
What is a sorter transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How do you update the records with or without using update strategy?
Separate from a database, an information bazaar, and an information stockroom?
What is the different lookup cache(s)?
What is meant by pre and post session shell command?
What are session parameters ? How do you set them?
