how can we extract data with out having any common column
- 7 Answers
- 14911 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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is ibm datastage?
What is the use of datastage designer?
State the difference between an operational datastage and a data warehouse?
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
What is the use of hoursfromtime() function in transformer stage in datastage?
Define ds designer?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Can you implement SCD2 using join, transformer and funnel stage?
Is the value of staging variable stored temporarily or permanently?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is the difference between an operational datastage and a data warehouse?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
