i have the source from Uk,north america how can i pass the
data two tables based on the locations
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 |
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
what is factless fact table?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
How one source columns or rows to be loaded in to two different tables?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
how to cleansing data
Which commands are used to import and export the datastage jobs?
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz