Answer Posted / avinash

JUNK DIMENSION
A Dimension which cannot be used to describe the facts is
known as junk dimension(junk dimension provides additional
information to the main dimension)
ex:-customer add

Confirmed Dimension
A dimension table which can be shared by multiple fact tables
is known as Confirmed dimension
Ex:- Time dimension

What is the difference between informatica and datastage?

1203

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3326

---

What are the types of hashed files in data stage

1098

---

how to delete one row in target dataset

3101

---

How can we improve the performance in datastage?

1093

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5104

---

How to find value from a column in a dataset?

2187

---

what is use of SDR function?

5159

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1493

---

To see hidden files in LINIX?

1511

---

What is a merge?

1139

---

Why fact table is in normal form?

1218

---

Describe stream connector?

1296

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2880

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2711

---