Answer Posted / jayam
Hash file is worked in key based . so lookup stage work on
comparasion of columns. so using hash file
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is merge stage?
What is ibm datastage flow designer?
What is the difference between orabulk and bcp stages?
What are the types of hashed files in data stage
What is job control?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How you can fix the truncated data error in datastage?
what are the devoleper roles in real time? plz tell i am new to 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?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are some prerequisites for datastage?
What is the roundrobin collector?
what is the use of surogate key in datastage
What are the primary usages of datastage tool?
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.