In Real Time what are the scenarios u faced, what r the
tough situations u have overcome, and explain about sessions.
Answers were Sorted based on User's Feedback
Answer / rakesh
To improve performance for the sessions. I changed the cache memory properties.
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / nikhil
Getting first job in Informatica and working with
transformations...
| Is This Answer Correct ? | 12 Yes | 24 No |
why do u use shortcuts in informatica.?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
Sequence generator, when you move from develoment to production how will you reset
who is the best faculty for informatica in hyderabad ameerpet?
Can you generate sequence numbers without using the sequence generator transformation?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
Can you copy the session to a different folder or repository?
What are active and passive transformations?
In which scenario did you used pushdown optimization?
How do you convert single row from source into three rows into target?
Performance tuning( what you did in performance tuning)
How do you create single lookup transformation using multiple tables?