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
1692.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 4733Source 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
1417query 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
1631I 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,
1189First 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,
1301how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
1098what 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 1779During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
944Post New Databases AllOther Questions
How to implement database security?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What is the difference between primary and candidate key?
How to shrink a database?
If the master device is full, how do I make the master database bigger?
what is transaction state, buffer management, shadow paging
can u combine pipeline parallelism and partition parallalism? how and whan?
What are the advantages of normalizing a database.
What is table scan and index scan?
What are the tools used for backup and ticketing?
What is difference between clustered, non-clustered and unique index?
What is Object Oriented model?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
How many indexes can be created on a table?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
