Answer Posted / subbuchamala

In the Output Column Derivation of Transformer Stage:

1. Way:
Str('0',6-Len(string)): Input_Col--->Output_Col

2. Way:
right("000000" : Input_Col),6) --->Output_Col

3. Way:
Right(Str("0",6) : Input_Col),6) --->Output_Col
Right(Str("0",3) : Input_Col),6) --->Output_Col

what is use of SDR function?

5171

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1387

---

What is a ds designer?

1068

---

Explain the importance of surrogate key in data warehousing?

1187

---

why do u need the IOS upgradation in a FC switch

2281

---

How will you move hashed file from one location to another location?

2149

---

whom do you report?

1925

---

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)

2382

---

What is the command line function to import and export the ds jobs?

1148

---

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

2628

---

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?

2174

---

What are the processing stages?

1099

---

Is possible to create skid in dim,fact tables?

2635

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

---

Explain Quality stage?

1150

---