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
- 6321 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
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Differentiate between odbc and drs stage?
What are data elements?
Define data aggregation?
Can you explain kafka connector?
Why do we use link partitioner and link collector in datastage?
What is a merge?
Can you explain how could anyone drop the index before loading the data in target in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how to delete one row in target dataset
Explain datastage architecture?
What are the different layers in the information server architecture?
What is the difference between an operational datastage and a data warehouse?
Describe routines in datastage? Enlist various types of routines.
