Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys,
Please design a job for dis requirement with
derivation(solution).
my source table like dis.
emp_no qualification
1 a
1 c
2 a
3 c
3 b
To loaded to target like dis
emp_no qualification
1 b
2 b
2 c
3 a
my requirement is
every employer have three qualifications i.e a,b and c.
what qualification missed in source table that will be move
to target systems.
Hope u got it the requirement. Right
Thanks.
- 0 Answers
- 2907 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
What is oci?
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
count number of deptno in a emp table?
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)
What are system variables and sequencers in datastage
How many nodes supported by a one cpu in parallel jobs?
How do you reject records in a transformer?
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...
0 Answers Alpharithm Technologies,
Teradata 
