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,
7180I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 117199how to join two flat file if they have diff. structure?how to join one relational and one flat file?
4 9460if 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 9662i 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 77671)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 361561)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
CTS,
1 7203MY 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 9163Post New Informatica Questions
What is decode in informatica?
What is the scenario which compels informatica server to reject files?
What is a grid in Informatica?
Performance tuning in UNIX for informatica mappings?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Write the program through which the records can be updated?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
can u give example for factless fact table
How can we improve session performance in aggregator transformation?
explain about unit testing? in real time?
What are the restrictions of union transformation?
What is enterprise data warehousing?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What will be the approach?
How we can create indexes after completing the load process?