how to change left and right links in join stage?
Answers were Sorted based on User's Feedback
Answer / katru prasad
By changing the Link orders in the Join stage.
Is This Answer Correct ? | 19 Yes | 0 No |
Answer / ankit gosain
Hi All,
Go to link ordering tab in Join stage and there you can
change the order of let, right and intermediate links.
Cheers,
Ankit :)
Is This Answer Correct ? | 4 Yes | 0 No |
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
difference between server shared container and parallel shared container
What are transforms and what is the differenece between routines and transforms?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how to run jon in unix back round process what is command use in runing a job?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
How can we run same job in 1 day 2 times
How to create a doccument in datastage?
Explain connectivity between datastage with datasources?
What is ibm datastage flow designer?
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
whats relation between configuration file and datasets?