How can you join flat file, oracle as a sources?
Answer Posted / kiran
hai vijay..,
See Whats the Question and please first clear ur
questions.then give proper answer boss.by using flat files
also u can join and populated to target.please clear ur
quetion.
Thanks & Regards
Kiran
09393363309
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
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?
What is the use of datastage director?
What is a quality stage in datastage tool?
What is the difference between odbc and drs stage?
what is repositery?
What is the roundrobin collector?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How and where you used hash file?
What are the types of containers?
How many types of hash files are there?
How to clean the datastage repository?
How to reverse the string using unix?
What are the difference types of stages?
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.
What are sequencers?