Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2356


what is the use of skid in reporting?

2365


how many rows sorted in sort stage by default in server jobs

3984


What is use Array size in datastage

1764


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3104


Can you explain repository tables in datastage?

1387


What is the difference between the local container and shared container?

1082


What is merge stage?

1283


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2172


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2042


What are routines in datastage? Enlist various types of routines.

1084


Triggers,VIEW,Procedures

1214


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)

2365


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

921


how to implement scd2 in datastage 7.5 with lookup stage

5590