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 you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
DELL,
2 8215Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
1 2119In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
8 14777Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
4 10747I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
IBM,
3 6318I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
3 10021
how to generate the test data in sas without input data? : Sas-administrator
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
What are the data types present in bo? What happens if we implement view in the designer and report?
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 ?
Explain scd type 3 through mapping.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is the purpose of Dataware Control?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What r the names of the reports that you prepared?
Write the unconnected lookup syntax?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance