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 the other factors of the database on which the loading performance depend?
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?
Explain bus schema?
What is a fact, dimension, measure?
Explain about scorecarding?
What is the difference between rollup and scan?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What is the way to execute pl/sql script using informatica mapping?
How can we improve performance of data stage jobs?
Your i-sever crashed. What will you do?
What is data caches/ index caches?
Give one reason when you need to consider multiple data processing?
Name some categories in sas 9? : sas-grid-administration
Which transformation we use to convert 'NA' to 'Not Available'
What is sq transformation?