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
- 20811 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 |
What are sequencers?
If the job aborted in a sequencer, how can we start that from the previews successful job.
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
What is datastage engine?
detail about sdlc
Is there any possibility to generate alphanumeric surrogate key?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
How to move data set from one server to other?what are the steps to follow to do this?
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
Teradata 
