Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinivas
I will add some points to first answer
Source system send the raw data what ever data they have simply they will send to us.
In staging we do the cleansing, remove-duplicate and null handling process and load the data into staging tables.
Then we applying business logic's and loading into dim and fact tables.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Difference between server jobs & parallel jobs?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to read the length of word in unix?
What is ibm datastage flow designer?
What is the difference between the local container and shared container?
Where do the datastage jobs get stored?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Define data aggregation?
What are the functionalities of link partitioner and link collector?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How you Implemented SCD Type 1 & Type 2 in your project?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
