Interested to Buy Any Domain ? << Click Here >> for more details...
what is stage is used for below
Input columns: dept|mgr|employee|salary
Output columns: mgr|count of employee per mgr|avg salary per dept
note: each dept has one mgr and each mgr has many employees
- 0 Answers
- 1028 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain Quality stage?
What is data partitioning?
What are the types of containers and how to create them?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
On which interface you will be working as a developer?
What is merge stage?
what is the use of invokation id
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
ename like ibm,tcs,hcl need display those records only how?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
Teradata 
