Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between lookup stage reject link and
merge stage reject link in datastage Parallel jobs? interm
of output in Merge Reject link and Look Up Reject link ?
- 4 Answers
- 13895 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sharan
Lookup stage reject link captures unmatched primary entries
and Merge stage reject links captures unmatched secondary
entries.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / sharan
Lookup stage reject link captures unmatched primary entries
and Merge stage reject links captures unmatched secondary
entries.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / bharath
Lookup stage reject link captures unmatched primary entries
and Merge stage reject links captures unmatched secondary
entries.
In lookup stage only one reject link and one ref link is possible, where as in merge, n ref having n rejects...
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / pnvnreddy
Lookup stage reject link captures unmatched primary entries and Merge stage reject links captures unmatched secondary entries.
In lookup stage have only one reject link where as in merge stage if we have n updates then it will support zero or n reject links(in between zero to n doesnt accept)
Here Update1 unmatched secondary records will capture at reject1, Update2 will capture reject2..... so on.
| Is This Answer Correct ? | 1 Yes | 0 No |
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
what is the use of DSattchJob?DetachJob? where can we find it?
What is a delta record? How you will read it?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
how many rows sorted in sort stage by default in server jobs
HOW CAN WE SEE THE DATA IN DATASET?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
What are the main differences you have observed between 7.x and 8.x version of datastage?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
what is usage of datastage with materialized views
Differentiate between Join, Merge and Lookup stage?
Teradata 
