Explain the ChangeApply stage?
Answers were Sorted based on User's Feedback
Answer / naga
change capture- it takes two i/p links and one o/p link,It returns a change code in that change records returned into o/p links.It returns both source data and updated records Based on change code we can evaluate data.
ccode-- 1 indicates record not in 1st file
2 indicates record not in 2nd file
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vinay
vinnu_l@rediff.com plz send the documents to this id
thanks in advance
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / murari
murari.px@gmail.com....please send doc to this id....
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ilias
smd.iliyas@yahoo.co.in ...please send doc to this id....
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prasad
svprasad.555@gmail.com please send brief doc of datastage
thank you
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / satish
iamdbass@gmail.com
please send brief doc of datastage
thank you
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chinni
please send the datastage manual.
ch.chinni@gmail.com
Is This Answer Correct ? | 0 Yes | 0 No |
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?
Pls tell me what is troubleshooting in datastage view?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
how many types of sorting the data in data stage?
How you Remove the Dataset in Unix?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
What is the difference between passive stage and active stage?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
How to read the length of word in unix?
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
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 many types of remove the duplicate records?