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)
1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?
2 10914I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
2 6276data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
2 5977Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
IBM,
4807In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
5 8932. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
3 7018how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
IBM,
1 5186can 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...................................
2319Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
11 24857In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
2 8764In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
1 8042
Plz can any one say me how to get the informatica certification materials and dumps
What is the difference between constraind base load ordering and target load plan?
Difference between stored procedure and macro?
Could you explain what is enterprise data warehouse?
hi,can you please share with me about,what is reportlimit,report order and how can create and use
Can we get 1st record through Informatica(without sequence number).
What are the performance considerations when working with aggregator transformation?
How many number of sessions can one group in batches?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
explain in detail about type 3?
What is the maximum and minimum length of macro variable
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
How transaction file different from that of a sort file?
Explain usage analysis in datastage?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
