How to write a left outer join condition by using
Transformer stage in server jobs?
Could any one help me?
Answer / rakesh
default is left outer join Dude you just make sure in transformer you joiin them based n the key, that's it
Is This Answer Correct ? | 3 Yes | 10 No |
Could anyone give brief explanation bout datastage admin
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
What are operators in datastage?
What is the precedence of stage variables,derivations, and constraints?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
What are the differences between datastage and informatica?
What all are the different way to run a job?
How many Nodes configuration file you used in your last project?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
how does work server jobs?