Answer Posted / ananda
Join: When volume of data is more than 10 million in both
source and reference link.
Sparse Lookup: When reference data is > 500 million and
source data is <10 million.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is meta stage?
how many rows sorted in sort stage by default in server jobs
What is the use of datastage director?
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 ?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How many types of hash files are there?
What is quality stage?
Differentiate between operational datastage (ods) and data warehouse?
If you want to use a same piece of code in different jobs, how will you achieve this?
Describe routines in datastage? Enlist various types of routines.
Can you explain how could anyone drop the index before loading the data in target in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage 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...
What are the stages in datastage?
