Answer Posted / charan

hi this is charan
in sequential file there is no distinct keyword.But we use sequential file properties reject mode=output and then use remove duplicate stage based on key column(here we can't store the duplicate records).

Distinguish between informatica & datastage. Which one would you choose and why?

1007

---

Differentiate between data file and descriptor file?

1053

---

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

3249

---

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

---

Name the different sorting methods in datastage.

1048

---

What is the precedence of stage variables,derivations, and constraints?

1078

---

table actions available in oracle connector?

1605

---

Which warehouse using in your datawarehouse

2184

---

Lookup constraints

1249

---

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

2149

---

explain about citrix scheduling tool in datastage

2450

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1109

---

what is use of SDR function?

5171

---

What are routines in datastage? Enlist various types of routines.

1100

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188

---