Interested to Buy Any Domain ? << Click Here >> for more details...
how to capture rejected data by using join stage not for
lookup stage. please let me know
- 3 Answers
- 20734 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / karn khera
Use FULL OUTER JOIN....the non matching records will be having null values....after join put a transformer and collect rejected data by Isnull() function..... cheers :)
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / vz
We can not capture the reject data by using join stage.
For that we can use transformer stage after join stage.
| Is This Answer Correct ? | 17 Yes | 5 No |
Answer / prasad
Instead of Transformer, use filter stage, it will gain performance
In Filter stage: use two Links
1st link: Where(clause)=column_name<>''
2nd link: Where=column_name='' (Reject data)
U will get O/P
| Is This Answer Correct ? | 4 Yes | 1 No |
AGGREGATOR default datatype
what is the custome stage in datastage? how can we impliment that one? plz tell me
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
How many number of reject links merge stage can have?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
What is a datastage job?
What is "fatal error/rdbms code 3996" error?
Difference between JOIN,LOOKUP,MERGE?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
describe the Steps to confiure a Qlogic switch
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
How to perform incremental load in datastage?
Teradata 
