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,
7137I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 114770how to join two flat file if they have diff. structure?how to join one relational and one flat file?
4 9320if 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 9506i 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 76691)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 359461)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
CTS,
1 7131MY 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 9015Post New Informatica Questions
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How can we improve session performance in aggregator transformation?
Can we get 1st record through Informatica(without sequence number).
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How do you set a varible in incremental aggregation
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Define update strategy?
What do you mean by enterprise data warehousing?
How to open an older version of an object in the workspace?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Why update strategy and union transformations are active? Explain with examples.
What happens when a session fails and you click on recover?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs