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
No Answer is Posted For this Question
Be the First to Post Answer
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
What is diff between Junk dimensions and conform dimension?
How do you load 10 different sources with 10 different layouts to 10 different tables?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are operators in datastage?
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?
Difference in the implementation of lookup and join stages,in joining two tables?
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
how to cleansing data
what is main difference between change capture and change apply stages