Define repository tables in datastage?
No Answer is Posted For this Question
Be the First to Post Answer
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
What is size of a transaction and an array means in a datastage?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
ename like ibm,tcs,hcl need display those records only how?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the areas of application?
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.