i have the source from Uk,north america how can i pass the
data two tables based on the locations
Answer Posted / shar
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 |
Post New Answer View All Answers
Which commands are used to import and export the datastage jobs?
What are the different options associated with dsjob command?
project Steps,hits, Project level HArd things,Solved methods?
describe the Steps to confiure a Qlogic switch
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Where do you see different stages in the designer?
What are the benefits of datastage?
What are the types of containers in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
Lookup constraints
How to read multiple files using a single datastage job if files have the same metadata?
How a server job can be converted to a parallel job?
What are stage variables and constants?
Terminate Activity
What is the different type of jobs in datastage?