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 |
can we see the data in fixed width file? how can u change the datatype of fixed width files?
What is ibm datastage flow designer?
How can one find bugs in job sequence?
What are stage variables and constants?
whats difference between ls -ltr and ls -lrt?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
how do u catch bad rows from OCI stage? And what CLI stands for?
how can i abort the job if i get more than 100 errors in job log?
What is the sortmerge collector?
What is the difference between server job and parallel jobs?
How to Convert the columns into rows?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?