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
- 20849 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 |
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
on how many columns we can perform aggregation in the Aggregator stage?
How can remove duplicates in a file using UNIX?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are the functionalities of link partitioner and link collector?
What could be a data source system?
Where do the datastage jobs get stored?
Could anyone give brief explanation bout datastage admin
In one project how many shared containers are created?
What is exact difference between Parallel Jobs and server Jobs..
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
Teradata 
