Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Databases AllOther Interview Questions
Questions Answers Views Company eMail

what is tkprof tool and how it is used???

Genpact,

1947

give a simple example of physical and logical data independence

1688

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

1332

.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 3539

Source 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

Miracle Software,

994

query 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

Verizon,

1254

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

IBM,

832

First 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,

899

Clipper / DBF error

1 1371

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

734

what 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 1164

Explain about ur projets on teradata???

Wipro,

941

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

568

Under which circumstance should you create an index on a table?

3i Infotech,

225

What is a super key?

3i Infotech,

200


Post New Databases AllOther Questions






Un-Answered Questions { Databases AllOther }

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

832


What is the function of cluster index?

206


What are the advantages of using database?

142


wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

1988


Explain about ur projets on teradata???

941






can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

1297


Explain entity type?

196


What is ole db in ssis?

163


What is the advantage of varchar2 over char?

246


Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

490


what is the role of auditor in auditing data oriented applications?

1544


What is database bounce?

145


What is redis good for?

145


how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

1101


5. Explain about relational algebra.

1310