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)
. In production reports, some dimensions are missing. how do you load these dimensions in production
TCS,
2 5699There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?
1 305912. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?
3 12509What are the different types of code pages available in informatica & how to implement it in your project?
TCS,
1 10781whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
1 3950
Explain in detail about scd type 1 through mapping.
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
Explain about a tricky situation for which you found a very simple solution?
create a job that splits the data in the Jobs.txt file into
four output files. You will direct the data to the
different output files using constraints. • Job name:
JobLevels
• Source file: Jobs.txt
• Target file 1: LowLevelJobs.txt
− min_lvl between 0 and 25 inclusive.
− Same column types and headings as Jobs.txt.
− Include column names in the first line of the output file.
− Job description column should be preceded by the
string “Job
Title:” and embedded within square brackets. For example, if
the job description is “Designer”, the derived value
is: “Job
Title: [Designer]”.
• Target file 2: MidLevelJobs.txt
− min_lvl between 26 and 100 inclusive.
− Same format and derivations as Target file 1.
• Target file 3: HighLevelJobs.txt
− min_lvl between 101 and 500 inclusive.
− Same format and derivations as Target file 1.
• Rejects file: JobRejects.txt
− min_lvl is out of range, i.e., below 0 or above 500.
− This file has only two columns: job_id and reject_desc.
− reject_desc is a variable-length text field, maximum
length
100. It should contain a string of the form: “Level out of
range:
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Write the unconnected lookup syntax?
What is aggregate table and aggregate fact table ... Any examples of both?
What r the names of the reports that you prepared?
how many reports have u created ? explain a few.
Explain what is aggregate table and aggregate fact table ... Any examples of both?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the data types present in bo? What happens if we implement view in the designer and report?
How to add default rules in transformer?
EXL informatica Questions
