How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
Answer / ravi
Take PK of records inserted in 1st extraction from Target Database table. Write a query to exclude these records from client DB in 2nd extraction.
Is This Answer Correct ? | 1 Yes | 0 No |
How you Remove the Dataset in Unix?
Whats difference betweeen operational data stage (ods) and data warehouse?
how to remove duplicates in transformer stage by using stage variables?one example?
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....
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
when we will use connected Lookup & Unconnected Lookup
what is the diff between sequential file and fileset stages?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
What is process model?
How do you import and export the datastage jobs?
How do you start developing a datastage project?
What are stage variables and constants?