can any one give some examples for pre sql and post sql(Except
dropping and creating index).
No Answer is Posted For this Question
Be the First to Post Answer
what is threshold error in informatica?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
what is difference between mapping and mapplet ?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
Can you copy the session to a different folder or repository?
All active transformations r passive or not?
Can you generate reports in Informatcia?
Explain the features of connected and unconnected lookup.
my 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
Can informatica load heterogeneous targets from heterogeneous sources?
Can we get 1st record through Informatica(without sequence number).
how to join the 2 different table with different columns in informatica?