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



i have the source from Uk,north america how can i pass the data two tables based on the locations..

Answer / 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

i have the source from Uk,north america how can i pass the data two tables based on the locations..

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

Post New Answer

More Data Stage Interview Questions

how can u connect the client system directly at any time?

1 Answers   IBM,


What is PX?

2 Answers   IBM,


Describe routines in datastage? Enlist various types of routines.

0 Answers  


Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,


what is datastage job Monitoring

6 Answers   CTS,






How we can convert rows to columns in datastage?

4 Answers   IBM,


Can you explain tagbatch restructure operator?

0 Answers  


what is main difference between change capture and change apply stages

4 Answers   IBM,


What are the various kinds of the hash file?

0 Answers  


Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,


What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,


what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,


Categories