how do u capture duplicates through sort & transformer
Answer Posted / kalyanreddy
Yes, Kirans is right
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the situation where you have applied SCD in your project?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is a ds designer?
What are routines in datastage? Enlist various types of routines.
What is apt_config in datastage?
I have a few records just I want to store data in to targets cycling way how?
What is job control?
describe the Steps to confiure a Qlogic switch
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
what is the use of surogate key 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?
To see hidden files in LINIX?
Demonstrate experience in maintaining quality process standards?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)