What is confirmed Dimension?
what is Factless Fact? give one example?
What are Additive, Semi-Additive Facts?
Answer / srinu
The Dimension table which is shared by more than one fact
table is called confirmed dimension
Eg: Time Dimension
The fact table which doesn't have any fact information is
called factless fact table
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the difference between an operational datastage and a data warehouse?
what is set mapping in datastage??
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
Why do we use link partitioner and link collector in datastage?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
Name the third party tools that can be used in datastage?
What is a folder? Difference types of stages?
What is the difference between hashfile and sequential file?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time