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 9789i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
1 22951.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 11811A 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 6694I 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 5079Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 11322I 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 25584it is possible to load two tables data into one sequential file?if possible how?plz share with me?
6 9653i 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 9131Post New TCS Data Stage Interview Questions
What are advantages of using LINQ on DataSet?
What is mvc framework?
What role does an abap program play in sapscript?
What is the scope of MBA (International Business). Basically I am B.sc (Chemistry). I have finished MBA(IB) 2010. Anybody please guide me to improve my career.
what are the basic knolwedge required for resource manager
Can you please explain the difference between thread and process?
What's the smallest font on word?
How to enable error log in codeigniter?
How do you remove lines from a table?
A number of critical bugs are fixed in software. All the bugs are in one module, related to reports. The test manager decides to do regression testing only on the reports module.
Differentiate between induced emf and self inductance?
How can we calculate cable size in Low voltage & high voltage
How can we embed Video in HTML 5?
While creating workflow on task object, what difference observed on available actions?
What do you mean by spider?