in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
L&T,
11 33948Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
2193what is rank and dense rank in informatica with any examples and give sql query for this both ranks
4 27643I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
1 3678what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 15032What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
12493how to read data from website into informatica? plsss send answers ASAP thanks in advance.
DELL,
1 8073how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
CTS,
3 14147
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.