Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60
TCS,
1 5137Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
TCS,
2070How to set tracing level for PowerCenter Informatica. Do we need to give tracing level in each and every mapping or is there any option to change tracing level commonly for all mappings. ?
2283I have 2 yrs ex in informatica and i am planning to do the certification. Can you please send me all the details on mcaprasad24@gmail.com thanks
1832my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
HP,
3 6455How we will implement Pushdown Optimization and Types in Informatica with better examples
TCS,
4 12579i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
5 10313Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
1 40131)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
6513
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
how do u implement configuration management in Informatica?
can be used COM component in Informatica ?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
how do u handle performance issues in Informatica . where can u monitor the performance ?
list and discuss two approaches for updation of target table in Informatica and how they are different.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Identifying the bottlenecks in various components of Informatica and resolving them.