Answer / madhusudhan reddy.d

A fact table without any facts is known as factless fact
table. Always a Fact should be a Numeric value but every
numeric value need not be a fact.

Answer / srinu

a facttable relation with dimension table as
forgienkey,bussiness transaction data and without facts is
called factless fact table

Answer / chaitanya

The fact table without any facts is called the factless fact
table.

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

Unix command to view the data in a dataset

2 Answers   IBM,

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

---

---

Define orabulk and bcp stages?

0 Answers  

---

sed,awk,head

0 Answers   CTS,

---

Define APT_CONFIG in Datastage?

0 Answers  

---

What are the steps required to kill the job in Datastage?

0 Answers  

---

What are the types of views in datastage director?

0 Answers  

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---