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
1631Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
IBM,
2 8582What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
IBM,
1886What is best approach to load 100 different source files (Different structure) to differet target tables ?
2 9842How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
IBM,
2 8806If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
2 7922Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
TCS,
2 7317In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
1 5981In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
5 7856please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
1 5249Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
5 7888Post New Informatica Questions
What is the different lookup cache(s)?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is the Default Source Option For Update Strategy Transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain sessions. Explain how batches are used to combine executions?
Explain pmcmd command usage in informatica
How to do unit testing in informatica? How to load data in informatica ?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Why do we need informatica?
explain abt ur project architecture?
What are the different types of olap? Give an example?
tell me 5 session failure in real time how can you solve that in your project?
How do you handle two sessions in Informatica
What are the types of schemas we have in data warehouse.
What is different between the data warehouse and data mart?