Answer / phani kumar

NO.As a Fact table, it contains foreign keys for maintaining
relationships and measures for analyzing the business as
year/half-year/quarter wise.

Answer / kiran

In a factless fact table we can have "textual information".

Answer / reddymkl.dwh

NO, Junk dimension have textual information.

Answer / rajesh

ANS: We can put textual information but not useful, actually
in FACT table, in contains numeric value for calculating
measurement like sales, profit/loss, revenue, date/time,
production, stock etc. in Fact table, it contains foreign
keys for maintaining relationships and measures for
analyzing the business as week/ month/quarter/year etc.

Answer / venkat

Hai phani Kumar,

your answer is wrong
Fact table stores Multi part keys,KPI,Meassures
...
U r saying fcatlessfcat table

Answer / sreeni

fact table contains 2 segment dimension keys with measurements
if contains  numeric values of what u mesure

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

What is job control?

0 Answers  

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,

Where the datastage stored his repository?

0 Answers  

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

Thanks to all people who are posting their comments...

1 Answers   CTS,

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

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

0 Answers  

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers