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 10748i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
1 27891.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 12894A 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 7347I 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 5650Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 12268I 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 27932it is possible to load two tables data into one sequential file?if possible how?plz share with me?
6 10636i 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 10277Post New TCS Data Stage Interview Questions
What is sampling density for image processing?
Explain the difference between check point and output value?
sir i applied for hpcl(electrical).i want to know from which subjects most of the technical que will b asked.and pattern of the written test.pls help me
when do you use "caninvoke(false/true)" method in scripting?
did any one attended interview in applabs if you had gone through plz tell me the procedure
What is the importance of 'Manager Properties' on CRM components?
What is jpanel swing?
How do I count specific text in excel?
What are the responsibilities of a site manager?
What is methodological theory?
What is the term bms in cics?
What is problem?
What is use of count() function in php?
How can we schedule apex programs ?
How do I get rid of unwanted text in excel?