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) Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load
4 7787I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?
2 6144How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
IBM,
2 13666hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
1 4528while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?
PWC,
2 7398Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
TCS,
2 54741)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
PWC,
3570what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
HCL,
3 11602in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
HCL,
2 17017i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
1 4907
What is the difference between nodupkey and nodup options?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is a pre-defined event and user-defined event?
Differentiate between reusable transformation and mapplet.
Does microstrategy web support clustering via cisco local router or any other third-party clustering software?
Explain the difference between powerplay transformer and power play reports?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
how we can load rejected record's at run time?(not through bad files)
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is type 2 version dimension?
What is node? How many nodes and amps used in your previous project?
Why sorter is an active transformation?
Differentiate between hash file and sequential file?
What are the difference between sas functions and procedures?