what we require for D.modelling?
Answer / vaibhav bhandeo
Data modelling requires understanding of the requirements.
In general the design of data model can be a snowflake
(Highly normalized) or star schema (partial or not
normalized) which depends on whether you want optimal
utilization of space (Use star schema) or you want a
normalized data model easy to query and acess data (Use
snow flake).
Is This Answer Correct ? | 1 Yes | 0 No |
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Target is zero file and how can you send the email?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
what are challenges that you faced in testing? give solution to it?
Normalizer transformation is not involved in Mapplet.. why???
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
have u done any performance tuning? how u ll do?
whether Sequence generater T/r uses Caches? then what type of Cache it is
Differentiate between reusable transformation and mapplet.
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
What will be the approach?