How can we select pr retrieve the particular row in dataset
by using orchadmin command?
what about data stage requirement
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
What are the differences between datastage and informatica?
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
which dim, fact tables used in bank domain
What's the Main Function of the Staging area in DWH
How can we do null handling in sequential files?
how can u handle null values in transformer stage.
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
In merge stage can we update the values?
How will you move hashed file from one location to another location?