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 9178hi 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 7787How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...
2 6669create 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 29895what 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 8448I 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 5221Guys... 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,
2889I 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 3989Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
IBM,
2768I 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 4536
How to create an external dataset with sas code?
Which development components of informatica have the highest usage?
What do you know about sas and what we do? : sas-grid-administration
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Explain what would you consider as your biggest achievement and why?
What is the work of tranwrd function?
How does proc sql work?
What are active and passive transformations?
what are all the reports you generated in your recent project?
Implementation methodology
According to you, what are the most important tables in a dw? Why?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What are the static cache and dynamic cache in informatica?
