1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

In Real Time what are the scenarios u faced, what r the
tough situations u have overcome, and explain about sessions.

Question Posted / sujatha.kaliki

Answers were Sorted based on User's Feedback



In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and expla..

Answer / rakesh

To improve performance for the sessions. I changed the cache memory properties.

Is This Answer Correct ?    11 Yes 4 No

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and expla..

Answer / nikhil

Getting first job in Informatica and working with
transformations...

Is This Answer Correct ?    12 Yes 24 No

Post New Answer

More Informatica Interview Questions

How to add source flat file header into target file?

3 Answers   Logica CMG,

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,

what is mapping optimization? wat are the techniques for tat

2 Answers  

tell me the push down optimization

2 Answers   Wipro,




What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

Where can we find the throughput option in informatica?

0 Answers  

How many repositories can be created in informatica?

1 Answers  

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories