Interested to Buy Any Domain ? << Click Here >> for more details...
-
Teradata (490) - Business Objects (875)
- Cognos (1143)
- Informatica (2428)
- Crystal Enterprise Suite (30)
- Actuate (46)
- Ab Initio (442)
- Data Stage (917)
- SAS (1049)
- Micro Strategy (282)
- ETL (315)
- OBIEE (92)
- IBM Cognos TM1 (55)
- Amazon Redshift (62)
- Data Warehouse General (749)
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
3 70443. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
7 12807What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
CTS,
2 5975hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
2071hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
1 5466Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
2 6091Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
3 12581Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
HCL,
1 4856A 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?
TCS,
1 8329I 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?
TCS,
1 6588Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
3 13801
lookup transformation with screenshots
What are the components of report net?
What are the various tools? Explain name a few?
Name the command line functions to import and export the DS jobs?
---------------Describe OLAP Reporting and RDBMS Reporting?
How do you load alternate records into different tables through mapping flow?
Explain can report net connect multiple datasource at a time in report creation time?
what are the session parameters? How do u set them?
What are the steps involved in creating dimensional modeling process?
Explain when we use aggregate awareness function in designer?
What are the features of base sas system?
Difference between e-r modeling and dimentional modeling?
How will you execute direct sql in obiee?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How do you improve the performance of a graph?
