Answer Posted / arshad basha

Initially we cannot use the dataset as a source.cause it is an internal format creation of datastage. if the source file is in the format of flat file means then we select sequential file as a source and dataset as a target.After this creation we use the target as a source for the next step. .ds is the file extension of dataset.

What are the partitioning techniques available in link partitioner?

2279

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2633

---

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?

2179

---

Define project in datastage?

1093

---

Explain datastage architecture?

1402

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1276

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2865

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1088

---

What is the purpose of pivot stage and types of containers in datastage

1040

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

---

Which warehouse using in your datawarehouse

2185

---

State the difference between an operational datastage and a data warehouse?

1132

---

Lookup constraints

1257

---

How can we improve the performance in datastage?

1105

---