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 5219write 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,
2555i 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 8775As 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 5965Can 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 7042in 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 7913Hello , 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,
2863i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
CTS,
6 12980if 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 6285if i have a delimited file as source so how can we seperate this file into three diff targets?
TCS,
2 5488if the column name in sql override is diff from the column name in source qualifier,what is the impact?
TCS,
5 9616
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
What is the difference between drill through and masterdetail reports?
In informatics server which files are created during the session rums?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What do think which one is the better joiner or look up?
What are the five ways to do a table lookup in sas? : sas-grid-administration
How to run a graph infinitely?
What areas of SAS are you most interested in?
What is data analysis?
State the differences between sql override and lookup override?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Explain what are the mapping paramaters and maping variables?
What is a joiner transformation?
What is the difference between server job and parallel jobs?
Explain the main difference between the sas procedures and functions? : Sas-administrator
