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 |
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How many input links can you give to a Transformer stage?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
I have 100 records how can I load at a time from the single time
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
Difference between the Sequence and Sequencer in DS?
Triggers,VIEW,Procedures
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?