Interested to Buy Any Domain ? << Click Here >> for more details...
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
How many input parameters can exist in an unconnected lookup?
What are the types of caches in lookup? Explain them.
What are the types of caches in lookup?
Differentiate between router and filter transformation?
What is dimensional table? Explain the different dimensions.
What are the different lookup cache(s)?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are ETL Tools?
What are the performance considerations when working with aggregator transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is joiner transformation in informatica?
What is aggregate cache in aggregator transformation?
Under what condition selecting sorted input in aggregator may fail the session?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What do you mean by channel change?
