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
- 20978 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the custome stage in datastage? how can we impliment that one? plz tell me
Name the different sorting methods in datastage.
What are the different layers in the information server architecture?
What is the use of hoursfromtime() function in transformer stage in datastage?
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?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
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...
EXPLAIN SCD
What are the difference types of stages?
How many types of sorting methods are available in datastage?
What is the precedence of stage variables,derivations, and constraints?
Can we use target hash file as a lookup ?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Can you filter data in hashed file?
What is "fatal error/rdbms code 3996" error?
