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
- 6452 Views
- I also Faced
- E-Mail Answers
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
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Does datastage support slowly changing dimensions ?
Explain the importance of surrogate key in data warehousing?
Different ways a project can be moved to production ?...example ….export-import and Version control.
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 datastage engine?
What are orabulk and bcp stages?
How do u convert the columns to rows in datastage?
What is the difference between the local container and shared container?
What are stage variables?
What is difference between symmetric multiprocessing and massive parallel processing?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How can we improve the performance in datastage?
How do you reject records in a transformer?
What are the types of jobs we have in datastage?
