how to delete one row in target dataset
Define orabulk and bcp stages?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Why fact table is in normal form?
what are the errors,warnings in datastage
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 the difference between odbc and drs stage?
Which commands are used to import and export the datastage jobs?
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?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What all are the different way to run a job?
What is the purpose of pivot stage?