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)
how you migrate reports to cognos 8 from previous versions?
How do we load data into Redshift?
Can we create universe with no cache??
Given an unsorted data set, how to read the last observation to a new data set?
What is the profile and package?
Which is more efficient group by or distinct to find duplicates?
Explain how merging helps to combine data sets.
What are aggregate tables? How do you design them using teradata?
Highlight the limitations of TPUMP Utility.
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 ?
Explain the methods to improve performance of a graph?
How to set up valid email address and printer in Cognos, so can delivery the report by email or print it out?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
What is the difference between informatics 7x and 8x and what is latest version?
Explain what is the difference between olap and datawarehosue?