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,
HCL,
6829I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 100365how to join two flat file if they have diff. structure?how to join one relational and one flat file?
4 8133if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
5 8181i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
3 68101)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
CTS,
5 344031)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
CTS,
1 6671MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
4 8118Post New Informatica Questions
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are batches?
Please let me know how to make Data masking in informatica..
Explain sessions and how many types of sessions are there?
What is rank transform?
What is Data Caches size?
What is the sql query overwrite in source qualifier in informatica
Explain informatica architecture - version 8 / 9
What do mean by local and global repository?
What is aggregator transformation in informatica?
Different sorts of metadata that stores in the storage facility?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the conditions needed to improve the performance of informatica aggregator transformation?