If we are using an aggregator but forget to mention the group by port .what will be the output??
11 34182I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
4 10779If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
9 15954Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
5 11930Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
1 6935I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
3 8156HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
TCS,
3 10566Post New Informatica Questions
Differentiate between a repository server and a powerhouse?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the function of union transformation?
What is a filter transformation?
What is standalone command task?
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,
Can we create a Integration service without a Repository service and vice versa?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a passive transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a joiner transformation and why it is an active one?
How can we improve session performance in aggregator transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to create the source and target database connections in server manager?
How to update a particular record in target with out running whole workflow?