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 12561i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
1 38931.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 15131A 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 8332I 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 6589Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 13803I 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 31063it is possible to load two tables data into one sequential file?if possible how?plz share with me?
6 12909i 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 12483Post New TCS Data Stage Interview Questions
Tell me what are the steps involved in configuring the jms?
for fresh itm agent installation, what agent version should be used?
Why would a parent process terminate a child process?
What are the advantages and disadvantages of thread-safe jsp page?
Do you know how to configure DB2 side of the application?
How much gain in performance will I get if I write my number crunching routines in C instead of Visual Basic?
how to write html code with ssl
How should I get started with content marketing?
What is the xslt? : xslt
What is the difference between spring and spring boot? : Spring Boot
How to create a logo using pen tool?
What are chief characteristics of state-space method and its techniques ?
Can a static class have a constructor c#?
Why xml is used in web applications?
What is index awareness in universe?