Data Stage Interview Questions
Questions Answers Views Company eMail

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

IBM,

1737

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

Teradata,

6 10855

how many write modes are there in ds

IBM,

2 10390

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

Gallega, TCS,

5 12868

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 11775

difference between function and procedure...

IBM,

1 5437

if ename='subbu' while running job the job should be abort how come?

IBM,

3 7161

how to find diff between 2 dates without using Icon... funtions?

1 2907

how to find no.of records in sequntial file itself?

4 19641

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 5209

ename like ibm,tcs,hcl need display those records only how?

2 5463

convert yyyy mm dd to dd mm yyyy?

4 14505

how to closeing records after 10,000 records come?

3 5103

how to add a new records into source?

1514

in oracle target stage when we use load option and when we use upsert option?

1738


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2002


What is apt_config in datastage?

689


What are the different plug-ins stages used in your projects?

610


What is a ds designer?

631


What are the different kinds of views available in a datastage director?

590






How do you reject records in a transformer?

616


What are constraints and derivations?

637


How do you remove duplicate values in datastage?

614


Differentiate between data file and descriptor file?

610


How do you register plug-ins?

591


What are the features of datastage flow designer?

619


What is a datastage job?

608


What are the different common services in datastage?

690


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1034


What are stage variables, derivations and constants?

654