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 do you run datastage job from the command line?

0 Answers  

---

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

---

which memory is used by lookup and join

5 Answers   IBM,

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

Name the command line functions to import and export the DS jobs?

0 Answers  

---

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

what is materialized view used datastage?

1 Answers   HSBC,

---

What is usage analysis in datastage?

0 Answers  

---

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,

---

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

---

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---