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 10787i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
1 28071.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 12921A 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 7374I 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 5659Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 12292I 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 27979it is possible to load two tables data into one sequential file?if possible how?plz share with me?
6 10649i 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 10312Post New TCS Data Stage Interview Questions
Could any one share scripts... where we can Parameterize radio buttons and Check boxes.
Characterize bare-metal mode?
What is word-break property used in css3?
what is moisture probe? What are there types? What is there working principle and how they works? guys this is one of technical question I had ask in interview. If you know its answer please let me know. The interviewers were more interested in microwave moisture probe, so if you find its any link please just forward me on my mail id.avinash1200@gmail.com Thanks in advance.
How many normal and special peroids can be there in a fiscal year? How do you open and close periods?
What is wcf basic binding type?
Explain transparent caching with aop?
what is tracking? How do you enable it? What are the different ways of tracking? What happens when you enable tracking?
What are the important components of cohesion?
What is the practical way to calculate the cable size for known ampere load?
Explain how do you deploy your asp.net application?
Can you explain what a statistical condition is? Give an example for a statistical condition?
How does a seismograph works?
What version of windows do I have?
What is sh in shell script?