how can we extract data with out having any common column
- 7 Answers
- 14954 Views
- IBM, Switch2iTech, I also Faced
- E-Mail Answers
Answer Posted / sridhar
Use lookup stage .this scenario u will do through lookup
stage .But whatevr You joining columns datatype must be
same.cOrrect me if i am wrong
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are stage variables and constants?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Describe the architecture of datastage?
How the ipc stage work?
What are the job parameters?
Define Job control?
What is a ds designer?
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
Define Merge?
How do you schedule or monitoring the job?
What are datastage sequences?
How many Key we can define in remove duplicate stage?
sed,awk,head
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
