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 12318i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
1 37831.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 14840A 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 8230I 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 6484Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 13609I 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 30692it is possible to load two tables data into one sequential file?if possible how?plz share with me?
6 12633i 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 12122Post New TCS Data Stage Interview Questions
What do you know about Life Insurance?
Where is notepad exe located?
What is the function of a Amazon controller?
Which function allows you to instantiate an object given its programmatic identifier or progid?
What is the recommended approach for asp.net mvc to globally intercept exceptions? What other functionality can be implemented with the approach? : Asp.Net MVC
Explain about few error status codes of idms.
How many maps are there in a particular job?
how to add master page in aspx page that is design before master page....
How do I edit a header in word 2007?
What is unmannaged code and will CLR handle this kind of code or not .
Can corrupted files be repaired?
Explain the pipeline partition with real time example?
What is drupal region?
How to find all sibling elements in front of the current element using ?
how can we repair a soc-7 error?