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
- 20870 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 |
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
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 to manage date conversion in Datastage?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
What modeling tool do you use?
Why we need datasets ratherthan sequential files?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
Name the different sorting methods in datastage.
What could be a data source system?
What are the different options associated with dsjob command?
What are the enhancements made in datastage 7.5 compare with 7.0?
Teradata 
