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??
1 6968my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
2 5486Post New KPIT Informatica Interview Questions
What is compiled query?
what is the c source code for the below output? 5555555555 4444 4444 333 333 22 22 1 1 22 22 333 333 4444 4444 5555555555
What is Basic derivative filters?
How do u prepare test environment for ur application?
Mention some advantages of swift?
What is sub- prime lending?
Is array reference type in c#?
What is HSN? How do we apply it?
What is meant by substrates of enzymatic reactions?
What is the maximum of key fields and search fields allowed in a segment?
What is the use of customer account group?
What are wp hooks?
How to know, which are the bands (850,900,1800,1900) a mobile device supports?
When should the volatile modifier be used?
Compare and contrast between sql and sql server and explain its various functions?