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) /*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
2 4503A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
1 2571Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
3 7615Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
2 3971hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
1 3698This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
CTS,
2 9882eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
4 8504i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
2 5048
hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com
How do you remove duplicate records in informatica? And how many ways are there to do it?
Write the unconnected lookup syntax?
How would you format some text using css to be verdana and bold?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Are you involved in writing the inferential analysis plan? Tables specifications?
Explain about a time when you discovered a more efficient way to do a work task?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how many reports have u created ? explain a few.
Explain how to generate iqd file from framework manager?
What is node? How many nodes and amps used in your previous project?
what is document design in boxi,have u participate in that
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?