Interested to Buy Any Domain ? << Click Here >> for more details...
table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
- 9 Answers
- 15424 Views
- I also Faced
- E-Mail Answers
Answer Posted / venky
u can generate sequece generator for both the tables and u
can use joiner transforation,u can get 10 columns
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Why do we use exception activity in Datastage?
How many Key we can define in remove duplicate stage?
What are the components of ascential data stage?
What is quality stage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is usage analysis in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
why do u need the IOS upgradation in a FC switch
project Steps,hits, Project level HArd things,Solved methods?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the components of datastage?
What is merge stage?
What is the purpose of pivot stage and types of containers in datastage
How and where you used hash file?
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?
