Answer / hemachandra

If you want to prepare Reconciliation report source with
target use the datastage internal function DSGetLinkInfo.
This function will show you how many records extracted from
source link and how many records loaded into target link.

Answer / bi etl

selct count(*) from source table;

selct count(*) from target table;

Answer / vaibhav gupta

For reconcilation of date You can use tool 'WinMerge'

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

---

How many types of views are there in a datastage director?

0 Answers  

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers  

---

How to reverse the string using SQL?

0 Answers   CTS,

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

How can we run same job in 1 day 2 times

4 Answers   IBM,

---

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

---

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

---

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,

---