please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
1 4658please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
2 5335If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
1779tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
3 24635Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
5 6249what is the query for retrieve the unique values(not display the duplicates values) from single table?
IBM,
6 8088"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
9 9693Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated
IBM,
1 4410SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
16891,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 15824
Explain what Proc glm does?
What do you understand by active and passive transformations?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
Can you define transformer?
Why managing the data is important?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What is perform recovery?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to Create a folder using pmrep command?
Describe the ways in which you can create a macro variable?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
In banking domain how many Fact tables,Dimension table are present?
what do you mean by security filter?
what kind of system requirement is needed to run tm1 for a small installation?
What are the data types present in bo? What happens if we implement view in the designer n report?