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
2417.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 6135Source 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
1844query 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
2058I 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,
1553First 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,
1740how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
1611what 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 2577During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
1382Post New Databases AllOther Questions
Write a query to retrieve for many to many relationships?
What is the best database?
What is the best database software for small businesses?
Is it good to store images in database?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
How do I setup a database connection?
I 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
What is replicaset?
Explain the table term used in database.
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
What is the advantage of varchar2 over char?
How to shrink a database?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
How does database replication work?