Answer Posted / jeevan kumar medapati
this is the process of designing the data base.in real time
data base architech (or) data modeler design the data base
by using GUI base data base designing tool ERVIN.
3 types of data models can be defined (1)star data model
(2)snoflake data model
(3)galaxy data model
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Briefly define a session task?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a rank transform?
What is exclusive and normal mode for repository services?
What are the limitations of joiner transformation?
Explain what is informatica metadata and where is it stored?
How to improve the performance of a session using sorter transformation?
pmscmd startworkflow -sv
Name the different lookup cache(s)?
How to extract sap data using informatica? What is abap? What are idocs?
Explain in detail scd type 2 through mapping.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is incremental aggregation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is lookup change?