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) How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
1 4454I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
Amex,
2 4655What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples
2 4605What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
2 15595i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
HCL,
1 3679Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
CTS,
2 4679i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
HCL,
1 5014i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
HCL,
4 7326Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
4 7918Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
1 2078when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
3 6406
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
Explain scd type 3 through mapping.
what are the dimensions that you have in your current project?list them?
faq's on cognos
Write the unconnected lookup syntax?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is a rollup component? Explain about it.
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
How do you remove duplicate records in informatica? And how many ways are there to do it?
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 is node? How many nodes and amps used in your previous project?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com