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)
What are session parameters ? How do you set them?
How can you validate all mappings in the repository simultaneously?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
What is the profile and package?
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 ?
in general which algorithms for used?
Can you define metrics designer?
Can you filter data in hashed file?
Explain why fact table is in normal form?
What are the commands to make a new table, change a table and remove a table in teradata?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Mention what is the syntax for m_dump in abinitio?
What is the metadata extension?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
explain the methodology of Data Warehousing?(Polaries)