I have a few records all are same structures data, I want to
store data in multiple targets how?
Answer Posted / raman
Use the same job for loading by parameterizing the file
name the table name.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Define APT_CONFIG in Datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
how many rows sorted in sort stage by default in server jobs
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?
What is "fatal error/rdbms code 3996" error?
How the ipc stage work?
How a routine is called in datastage job?
What steps should be taken to improve Datastage jobs?
How can we improve performance of data stage jobs?
Differentiate between hash file and sequential file?
describe the Steps to confiure a Qlogic switch
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?