what is the difference between lookup stage reject link and
merge stage reject link in datastage Parallel jobs?
- 9 Answers
- 27027 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kiran
Reject link is a reject link in both merge and lookup
stage. I guess the interviewer is not sure about this
question. The difference between lookup and mergre stages
in terms of reject links is lookup allows single reject
while merge allows as many reject links as the update links
in the source. so Lookup---> single reject link, Merger--->
Multiple reject links.
| Is This Answer Correct ? | 17 Yes | 8 No |
Post New Answer View All Answers
What is the difference between informatica and datastage?
What are the stages in datastage?
What is the differentiate between data file and descriptor file?
Define ds designer?
AGGREGATOR default datatype
Can you explain how could anyone drop the index before loading the data in target in datastage?
How one source columns or rows to be loaded in to two different tables?
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 many Key we can define in remove duplicate stage?
Distinguish between informatica & datastage. Which one would you choose and why?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How do you run datastage job from the command line?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
