Interested to Buy Any Domain ? << Click Here >> for more details...
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance
issue. how to fix the performnce issue of the query.
- 0 Answers
- 4825 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain the types of lookup transformation?
HOw 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.....
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
List the transformation in informatica.
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
What are the types of maping in Getting Started Wizard?
what is the diff b/w target load plan and cbl?
What is target update override
What is the difference between writing a joiner query in ANSI style and THETA style?
What does command task mean?
what are challenges that you faced in testing? give solution to it?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
Teradata 
