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
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
what is the use of skid in reporting?
how many rows sorted in sort stage by default in server jobs
What is use Array size in datastage
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Can you explain repository tables in datastage?
What is the difference between the local container and shared container?
What is merge stage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are routines in datastage? Enlist various types of routines.
Triggers,VIEW,Procedures
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
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
how to implement scd2 in datastage 7.5 with lookup stage