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 s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
4 9097in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
1 2300what is the difference between copy object import objects using repositery manager which one is best
TCS,
1 42333.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
TCS,
1 2310in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
3 7545in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
3 10052Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.
HSBC,
6 18806i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
2 7938
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Write the unconnected lookup syntax?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to create the source and target database connections in server manager?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is a rollup component? Explain about it.
What is rollup component?
how to generate the test data in sas without input data? : Sas-administrator
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com