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)
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
TCS,
1 5333write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
TCS,
2617i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
4 8955As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
2 6056Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
GE,
2 7126in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
4 8122Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
IBM,
2905i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
CTS,
6 13195if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
TCS,
2 6379if i have a delimited file as source so how can we seperate this file into three diff targets?
TCS,
2 5610if the column name in sql override is diff from the column name in source qualifier,what is the impact?
TCS,
5 9777
What is derived metric?
What are the special input delimiters used in SAS?
What is the data type of the surrogate key?
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?
what is granularity in Data ware House?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
How to generate cubes in cognos?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
Where is teradata rdbms used?
Demonstrate experience in maintaining quality process standards?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
How transaction file different from that of a sort file?
ware house management system is used?
What is dimensional modelling?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
