1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
Data Stage Interview Questions
Questions Answers Views Company eMail

What is RCP

CGI, CTS,

5 19686

How can we achive parallelism

CTS,

1 6903

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

TCS,

4 8853

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

HCL,

1715

1)Source file contains one record, I want 100 records in target file.

 3 7769

Two source files contains same meta data third file contains different data types can I funnel that file.

 2 6818

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 5146

I have 100 records how can I load at a time from the single time

 1 4526

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 5808

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 7518

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3501

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

Cap Gemini,

11 17866

source file contains 100 records, i want 10 records in target file how it possible in datastage

IBM,

6 22419

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

IBM,

8 10777

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

TCS,

1 3373

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Highlight the main features of datastage?

613

explain about citrix scheduling tool in datastage

1808

How can one find bugs in job sequence?

780

How can we improve the performance in datastage?

647

What could be a data source system?

573




What are the different options associated with dsjob command?

935

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1896

How to perform incremental load in datastage?

664

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

347

What are the important features of datastage?

616

What is quality stage?

568

What is the process of killing a job in datastage?

585

Define orabulk and bcp stages?

676

Different ways a project can be moved to production ?...example ….export-import and Version control.

1929

Difference between in process and inter process?

695

For More Un-Answered { Data Stage } Questions Click Here