1)How to Duplicate Records Delete in Sequential file?
Answer Posted / naga
connect sequential file to dataset and use partition
technique and perform sort and select unique
Is This Answer Correct ? | 19 Yes | 6 No |
Post New Answer View All Answers
What are the functionalities of link collector?
What is ds designer?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
what is flow of project?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the precedence of stage variables,derivations, and constraints?
Differentiate between odbc and drs stage?
How many types of sorting methods are available in datastage?
What is difference between join, merge and lookup stage?
Can we use target hash file as a lookup ?
How do you generate sequence number in datastage?
What is size of a transaction and an array means in a datastage?
On which interface you will be working as a developer?
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 one source columns or rows to be loaded in to two different tables?