Answer Posted / chenna
sparse lookup has more memory so that if reference table
contains huge amount of data perfer to use sparse lookup
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
how to delete one row in target dataset
Describe link sort?
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
Could anyone give brief explanation bout datastage admin
Is the value of staging variable stored temporarily or permanently?
What are the components of datastage?
What is apt_config in datastage?
What is merge stage?
what is the difference between == and eq in UNIX shell scripting?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
how to write server Routine coding?
What is the purpose of pivot stage?
How do you generate sequence number in datastage?
What are the different options associated with dsjob command?