Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / badhrinath r
look up stage performs the same action as merge and join
stages do. But here we have a table as lookup table which
will be having a key column with the source table. if the
key colums in source are matched with the lookup table, that
rows will only be passed to output. Others can be taken in
reject.
| Is This Answer Correct ? | 26 Yes | 5 No |
Post New Answer View All Answers
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Give an idea of system variables.
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Can you explain players in datastage?
root tree will find which is server job and which is parallel job?
why do u need the IOS upgradation in a FC switch
Define repository tables in datastage?
Can we use target hash file as a lookup ?
Differentiate between Join, Merge and Lookup stage?
What is datastage engine?
how to abort the job its matain duplicates?
What a datastage macro?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
EXPLAIN SCD
