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)
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
2 9184hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
3 7790How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...
2 6677create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
5 29907what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
2 8453I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
1 5226Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?
CTS,
2892I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?
1 3993Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
IBM,
2770I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
1 4539
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are the uses of etl tools?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
What are steps we have to follow in designing the userfriendly universe?
Mention how to limit decimal places for the variable using proc means?
Given an unsorted data set, how to read the last observation to a new data set?
Can microstrategy desktop access operational data systems?
How to generate the report from excel sheet?
What is a fact, dimension, measure?
What is session task and command task?
explain the difference between proc means and proc summary?
How we drill up week to month?
What are stage variables?
