Interested to Buy Any Domain ? << Click Here >> for more details...
i have the source from Uk,north america how can i pass the
data two tables based on the locations
- 2 Answers
- 6416 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
question incomplete.
but still we can differentiate recs of uk & america.
we can use col gen and assign a small code(uk/us) to rec(s) of each table and funnel them if they have same metadata and do the processing thing and load the processed rec(s) to target depending upon the business requirements.
However guys plz provide basic details in questions so that proper answer can be given.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pooja
Basically the question is incomplete and not clear.
Based upon my understanding, we can consider country codes
for the records if location is the main criteria which are
unique for every country and can be processed further.
What exactly needs to be done with the records is not
stated in the question.
| Is This Answer Correct ? | 0 Yes | 0 No |
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
how to call routines in stages?
What is quality stage?
how to call sequential generator in datastage?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
Does datastage support slowly changing dimensions ?
How to reverse the string using SQL?
What are the components of ascential data stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
What is the use of datastage designer?
Display all files which have size more 3KB in given directory/folder.
Teradata 
