How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
Answer / kalyan
If the stored procedure id used to do any operations on the
database tables (say Dropping the indexes on the tgt table
or renaming it or truncating it)then call them at the Pre
SQL and Post SQL options at the session properties of the
Target.
Is This Answer Correct ? | 12 Yes | 5 No |
in which situations do u go for scds ?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to generate sequence numbers using expression transformation?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
How to create Target definition for flat files?
Can we combine a flatfile and a database table using an UNION transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
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
How to eliminate duplicates from flat file..what is the procedure
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Performance wise which is better joiner or look up ? Give me with example?