Interested to Buy Any Domain ? << Click Here >> for more details...
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
- 4 Answers
- 8232 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pavani
if we have n duplicates
source---->transformer-------->target.
in transformer we define 2 stage variables
if empno=stg_var2 then stg_var1+1 else 1------->stg_var1;
emp_no-------->stg_var2;
now the constraint for target is stg_var1=2
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you start developing a datastage project?
What steps should be taken to improve Datastage jobs?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
why do u need the IOS upgradation in a FC switch
Differentiate between odbc and drs stage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is usage analysis in datastage?
How a routine is called in datastage job?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Why we use surrogate key?
Give an idea of system variables.
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Which warehouse using in your datawarehouse
What is the difference between odbc and drs stage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
