how to capture rejected data by using join stage not for
lookup stage. please let me know
- 3 Answers
- 19238 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you reject records in a transformer?
Where do you see different stages in the designer?
Can we use target hash file as a lookup ?
What is the difference between server job and parallel jobs?
Define APT_CONFIG in Datastage?
how to delete one row in target dataset
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
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is apt_config in datastage?
How many types of hash files are there?
Distinguish between informatica & datastage. Which one would you choose and why?
Why fact table is in normal form?
Name the different types of Lookups in Datastage?
Demonstrate experience in maintaining quality process standards?
What are the functionalities of link partitioner and link collector?
