How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
5 12575i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
1 38981.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 15142A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
1 8340I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
1 6599Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 13816I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 31081it is possible to load two tables data into one sequential file?if possible how?plz share with me?
6 12921i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
7 12501Post New TCS Data Stage Interview Questions
what is the use of jdftval in join logical file?
what is rocking arrangement in arc heating
What is the difference between the atomic theory and the kinetic theory?
How to format hard drive in windows xp?
How do I hide my wordpress site from search engines?
Why should I use jquery?
how can we know the number of days between two given dates using mysql? : Sql dba
What is rending process in ASP.NET?
What is the usage of Class selector?
What is object/relational mapping metadata?
How to read, write or remove session in codeigniter?
The properties of concrete HA-30 and how does it differ with M 30 (specify the important characteristics like workability,strength,mix design,slump test value)and what is the standard relating to it
How did you control the Arduino using python?
I download data which comes to me in a column. I want to use it in a complex sheet that needs data in a row. How can I convert the column data into row data?
If you tries to mount a share ( home directory )in a client machine, and it fails how do u approach?