Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
2412.dbf file corrupted Dear Friends, I am using DBF file in Foxpro. DBF file corrupt and show message "Not a database file" Waiting for your reply. With regards!
3 6131Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
1842query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
2053I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
IBM,
1550First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
IBM,
1738how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
1607what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?
OVGU,
1 2572During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
1380Post New Databases AllOther Questions
How do you pass parameter in stored procedure?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
How does database replication work?
List some advantages of dbms.
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
what are wrappers and build ups and what it's use?
what is the role of auditor in auditing data oriented applications?
What do you mean by foreign key and primary key?
What is Data Modelling?
How much does it cost to build a database?
How do I setup a database connection?
Differentiate between delete and truncate table?
What is ole db provider for sql server?
What is a driver in database?