Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Advantages of de normalized data?
- 3 Answers
- 9058 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kris
De Normalised Data:
A table storing denormalised data occupies more space
because lot of duplicate information creeps in when we
denormalise a table.
As less number of join conditions are required to retrieve
data from one/more denormalised tables, the performance
will be fast.
DWH environment prefers denormalised data structures.
| Is This Answer Correct ? | 27 Yes | 2 No |
Answer / mahesh
Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / eric yang
De-normalized data can save more space and have better
performance when run a sql for it
| Is This Answer Correct ? | 0 Yes | 21 No |
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
How to create Target definition for flat files?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is the procedure for creating independent data marts from informatica 7.1?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
Why is meant by direct and indirect loading options in sessions?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
in which situations do u go for snowflake schema ?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
What is a stored procedure transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Teradata 
