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)
difference between source based commit? and target based commit? which is better with respect to performance?
IBM,
6 19129Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
1 4494If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 9304Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 7804working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.
1 4660What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here
2 6539if we increase the number of dimensions will the rows in fact table increase or decrease??
IBM,
3 9592How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
1 4220How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
IBM,
1 5556Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
4 8037
How can we remove the duplicates from flat file source?
What are batches?
how we can generate cubes in cognos?
How can we check the version of Teradata that we are using currently?
------------- How to identify the Revenue Column in Report?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Why is chameleon method used in data warehouse?
How many project sources we can create in metadata?
Explain how to export mappings to the production environment?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Define enterprise data warehousing?
What are the processing stages?
What are the various transformation available?
Separate from a database, an information bazaar, and an information stockroom?
