hi all,
Can anyone please tell me the relationship between
informatica and business objects
By using infor matica we will design one to many relation
ship between fact and dimension tables..By using Business
object we will take those relational tables and will
prepare reports
| Is This Answer Correct ? | 0 Yes | 0 No |
How many number of sessions can one group in batches?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
What are Rapid changing dimensions?
Can we use parameters of parameter file in presession command
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
Do you have to change the reject file b4 using reject loader utility.