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,
6680I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 90391how to join two flat file if they have diff. structure?how to join one relational and one flat file?
4 7635if 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 7523i 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 63751)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 335591)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
CTS,
1 6390MY 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 7580Post New Informatica Questions
what is informatica metadata?
How can you differentiate between powercenter and power map?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the need of an ETL tool?
How can we create index after completion of load process?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is a standalone command task?
Is it possible to create multiple domains on a single Informatica server?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How are the sources and targets definitions imported in informatica designer?
How can we improve session performance in aggregator transformation?
What is meant by pre and post session shell command?
What are the reusable transformations?
What is a router transformation?
how to load rows into fact table in data warehouse
