how can we extract data with out having any common column
- 7 Answers
- 14996 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
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How a source file is populated?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
what is ds administrator used for?
How many types of sorting methods are available in datastage?
Explain the importance of surrogate key in data warehousing?
What is the difference between account and directory options ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the difference between hashfile and sequential file?
What are transforms and what is the differenece between routines and transforms?
what are the errors,warnings in datastage
which r the connectors used in san?
What are constraints and derivations?
how to delete one row in target dataset
What are routines in datastage? Enlist various types of routines.
