Interested to Buy Any Domain ? << Click Here >> for more details...
can u give example for factless fact table
- 2 Answers
- 6498 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivasulu raju
Factless fact table is used to track the Events.
Eg: Attendance System.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ankit kansal
Take two dimensions as dim_time and dim_product and
a fact table as fact_sales
Now provide a reference from both of the dim tables to the fact table and while loading from the source do not load any other data.
Now you can easily report out
product sold per day
product sold per month
product sold per year
e.t.c.
deepinopensource.blogspot.in
| Is This Answer Correct ? | 0 Yes | 0 No |
In how many ways we can create ports?
What are the Differences between connected and unconnected lookup?
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 are the types of caches in lookup? Explain them.
What are the advantages of informatica?
What is aggregate awareness?
Is informatica power center designer has 64 bit support?
Mention some types of transformation?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
How many input parameters can exist in an unconnected lookup?
permutations of mapplet
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Teradata 
