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 12738i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
1 39671.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 15339A 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 8410I 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 6702Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 13969I 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 31366it is possible to load two tables data into one sequential file?if possible how?plz share with me?
6 13112i 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 12729Post New TCS Data Stage Interview Questions
What is an alt tag for an image?
My Qualification is MCA.My interview is on 5th may.They may ask q as------AS u r MCA...Why u r not tring anywhere else? What can be the ans?
Is windows 7 better than windows 8?
What is a Port? What are the types of Ports?
How to deploy struggle or java purposes in apache?
What is the purpose of a secondary key?
Define standalone mode in hbase?
Can any suggest me what is exposure testing?
cin.ignore(80, _ _);This statement a) ignores all input b) ignores the first 80 characters in the input c) ignores all input till end-of-line d) iteration
What are the rules and regulations made by which telemarketers are limited to use the services? : insurance cold calling
Hi, I am USINg QTP tool for automation. Where VB Script have to use. I want to read a row from the table present in .Doc File and to paste in excel. Could you please assist me or give me the code to get it. I am new in this technology.
How do you ensure the quality and safety of anesthesia care, including protocols for medication administration, infection control, and equipment checks?
What is the most widely recognized info formats characterized in hadoop?
Is it possible to use same metastore by multiple users, in case of embedded hive?
Do all declaration statements result in a fixed reservation in memory?