Answer Posted / mrvprasad

1)First go to Seq File-->Columns-->Add RowNum column and
2)then go to Properties-->select Options-->select Row Number Column=RowNum (Drop down list select RowNum column)
we will get the sequence Numbers.

first do the link sort for Sal in transformer stage.

and in Transformer stage go to
Constraint: Mod(dslink1.RowNum,2)=0 ---o/p1

and then select otherwise check box or write Mod(dslink1.RowNum,2)=1 --->0/p2

What are the components of ascential data stage?

1240

---

Define orabulk and bcp stages?

1170

---

Which algorithm you used for your hashfile?

1230

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2778

---

Is it possible to query a hash file?

2057

---

How do you import and export data into datastage?

1291

---

What is the difference between informatica and datastage?

1299

---

How many areas for files does datastage have?

1214

---

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)

2442

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3518

---

What are transforms and what is the differenece between routines and transforms?

1103

---

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

2323

---

Describe routines in datastage? Enlist various types of routines.

1052

---

How can one find bugs in job sequence?

1489

---

Can you explain kafka connector?

1370

---